change the order and use stop if true
or
=AND( D8>A5+60, D8<A5+90)
you say A8 and you are using A5
you could use today()
is D8 the date you want to test
what is A5?
assuming D8
=D8<today()-90 for RED
=D8<today()-60 for Amber
=D8<today() for green - so today does colour
put in that order and stop if true
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks