Less than or Greater than

  • Thread starter Thread starter Andy B
  • Start date Start date
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
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Timestamp a cell when row is updated. 3
Excel Conditioning Formatting 3
Greater than and less than 4
colors and conditional format - greater than, less than 5
Excel 2007 Traffic Light with dates 6
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
Problem with Conditional Formatting and Greater than or equal too 1
Formula Greater than Less Than 4

Back
Top