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 Sheets
Інструкції до вправи
- 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.
Практична інтерактивна вправа
Перетворіть теорію на практику за допомогою однієї з наших інтерактивних вправ
Почати вправу