All dates except June
If you want to open your spreadsheet tomorrow and see the same results that you see today, you may want to use the options for static dates that don't shift with the passage of time.
In this example, you will be looking for all of the activity except for the month of June 2018.
この演習はコースの一部です
Google スプレッドシートの条件付き書式
演習の手順
- Add a conditional formatting rule to the dates in column
Bto highlight any cells with a date before6/1/2018with the Default green background, using the "Date is before" option. - Add another conditional formatting rule to the dates in column
Bto highlight any cells with a date after6/30/2018with the Default green background using the "Date is after" option.
