date formulas
 

I have the current, automatically updated date displayed on my spreadsheet.
How can I get the other dates on my spreadsheet to automatically change fill
colors when they become older than 30 days?

date formulas
 

Select the range of dates you wish to format. Select format conditional
formatting change from Cell Value Is: to Formula Is: and enter a formula
similar to:

=$A$3-A530

This formula has todays date in A3 and the date range starts in A5, edit as
needed. Click the format button to change formatting of any cell that meets
the older than 30 days criteria.
Have fun!

"Karl" wrote:

I have the current, automatically updated date displayed on my spreadsheet.
How can I get the other dates on my spreadsheet to automatically change fill
colors when they become older than 30 days?