Before last week
Now that you have seen how to conditionally format dates, let's highlight all of the items in this list that were made more than a week ago.
This conditional formatting rule should capture any date more than seven days before the present day and it won't have an endpoint.
When you do this type of conditional formatting, the spreadsheet is aware of the current date and it works from that day.
To ćwiczenie jest częścią kursu
Formatowanie warunkowe w Arkuszach Google
Instrukcje do ćwiczenia
Select all of the cells in the range of
D3toD16.Add a conditional formatting rule, use the "Date is before" option and select "in the past week", and select the Default option that formats with a green background.
Interaktywne ćwiczenie praktyczne
Przekształć teorię w praktykę dzięki jednemu z naszych interaktywnych ćwiczeń
Rozpocznij ćwiczenie