Less than or Greater than

A

Andy B

Hi
I am trying to write a formula that will flag when a date is exceeded by a
set number of days:
I.E. a specified date =<7days or >7days = "NO"
a specified date =<8days or >8days = "YES"

Is this possible and to colour the YES and NO red and green?
Thanks
Andy
 
L

Luke M

Your criteria is in conflict! The two options, <= 7 or >7 includes
everything, thus how can you get to your 2nd criteria.

As a start, you need something like
=IF(TODAY()>=B2+7,"Yes","No")
where B2 contains your speicfied date.
Also, as for the coloring, take a look at conditional formatting
(Format-Conditional Format)
 
Top