Conditional formatting using dates

Conditional Formatting in Google Sheets

Adam Steinfurth

Instructor

Highlight your dates

How dates and times are stored

• Dates are just numbers
• It's in the formatting

Short Date	Number
12/31/1999	36,525.00
1/1/2000	36,526.00
12/31/1999 12:00 pm	36,525.50

Let's practice!

Conditional Formatting in Google Sheets