Formatting cells - anyway to do this?

  • Thread starter Thread starter Sam Weber
  • Start date Start date
S

Sam Weber

Is there anyway to do something like:

If column "A"'s date is greater than 7 days old from the
current System Date, then format text in bright red.

This would be great if possible. Thank you for your time.
 
Select Column, do Format / Cond Formatting, change cell value is to (Assuming
this is column A) Formula is =A1<(TODAY()-7)
 
Highlight column A. Under the format menu there is an option called conditional formatting. Select this. Select "Cell Value is"..........."greater than".............Whatever cell you have the system date+7. Then click the format button and format however you desire.

Good Luck.
 
Back
Top