CODEWITHSUNDEEP
dategoogle-sheetsgs-conditional-formatting
Rurth
Rurth

Reputation: 21

Google Sheets Conditional Formatting Dates

New to Conditional Formatting. Looking to take a column of Dates (these dates are project end dates) compare them to Today's date and format them to change color whether they are 60 days prior to end date, 30 days prior to equal to end date (day of), and past end date.

Upvotes: 2

Views: 6650

Answers (1)

pnuts
pnuts

Reputation: 59460

Not sure this is exactly what you want (eg no formatting today>today+30, 60 days or more) but perhaps four rules, say all applied to Range A:A, where Custom formula is:

Red: =A1=today()
Dark red: =and(A1<today(),A1<>"")
Orange: =and(A1>today()+30,A1<today()+60)
Green: =A1>today()+30

Note that the order may make a difference.

Upvotes: 3

Related Questions