Greater than
In this scenario, you are analyzing the inventory in your warehouse and you would like to see which items are over-stocked.
You have decided that any items that you have more than 300 of need to be marked down with a "clearance" price and you need to show which items these are.
To ćwiczenie jest częścią kursu
Formatowanie warunkowe w Arkuszach Google
Instrukcje do ćwiczenia
- Highlight range
B2toB16and add a new rule in the conditional formatting window to the right. - Under Format cells if, select "Greater than" as the option and type 300 into the box.
- Leave the Formatting style as the Default green background, and click Done.
Interaktywne ćwiczenie praktyczne
Przekształć teorię w praktykę dzięki jednemu z naszych interaktywnych ćwiczeń
Rozpocznij ćwiczenie