Formatting cells - anyway to do this?

[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.

 

[Ken Wright]

Select Column, do Format / Cond Formatting, change cell value is to (Assuming
this is column A) Formula is =A1<(TODAY()-7)

 

[ACCT26]

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.