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)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Andy B" wrote:

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