IF Dates and conditional formatting (cell colours)

Hi

I have been asked to produce a spreadsheet of all outstanding queries we have as a business unit, I cannot paste the data due to confidentiality however what I have been requested to do is from the date of the query column I need a formula that says:


IF the date in say cells E1:E26 are 7 days old from TODAYS date so the NOW formula, the cell needs to either change to text "Yes" or change colour to red. Pls HELP

Alternatively if the dates in this column are not 7 days older than the last date entered then to read "No" or have a different colour or even no colour.

Hi and welcome to the forum.

For "YES", use this.

=IF($e1>today()+7,"YES","") OR you mean?

=IF($e1<today()+7,"YES","")

For color, in Conditional Formatting rules, use this.

=$e1>today()+7

Do you mean?

=IF($E1<TODAY()-7,"YES","")

OR

=IF($E1>TODAY()-7,"YES","")