Task 1 of 5
Highlight the requests that cost more than $500 in D2:D11.
Lesson theory
A property manager keeps a log of repair requests for an apartment building. Expensive, long-running, repeat and urgent requests should jump out on their own, with no manual coloring.
Tip: to highlight a whole row, select the entire table and write the formula for the first row with a $ before the column letter: =$F2="Urgent".
Enter — commit · F2 — edit · F4 — $ in a reference · Ctrl+C/Ctrl+V — copy and paste · Ctrl+Z — undo
Esc or F6 — leave the sheet for the «Check» button · Shift+Tab in the first cell — back to the page