CONDITIONAL FORMATING

[Kanmi]

Please i'm trying to conditional formating the cell and waht to figure out
which way is the best way n right formular to use. thanks for your ideas

greater than 90DAYS before this date 02/24/12 = GREEN
less than 90DAYS before this date 02/24/12 (that is 89days count down to
02/24/12) = YELLOW
pass the due date "02/24/12". That is 02/25/12 should turn to RED.

I tried to use CONDITIONAL FORMATING BUT i couldn't get the right formular
if you have any idea. please let me know. "Note" I want to apply this to row
and there are different date on each cell. Please advice on what to do.
Thanks.

 

[Bernard Liengme]

For the green condition, Formula Is =DATE(2012,2,24)-A1>=90
For the yellow condition, Formula Is:
=AND(DATE(2012,2,24)>=A1,DATE(2012,2,24)-A1<90)
For the yellow condition, Formula Is: =A1>DATE(2012,2,24)
where A1 is the cell you are formatting (or the first cell in a range you
have selected for formatting)

Your conditional actually missed out "equal to 90DAYS before this date
02/24/12
I included that in the green. Use these to include in the yellow
For the green condition, Formula Is =DATE(2012,2,24)-A1>90
For the yellow condition, Formula Is:
=AND(DATE(2012,2,24)>=A1,DATE(2012,2,24)-A1<=90)
best wishes

 

[Kanmi]

Thanks alot for your imput and ideas.
The issue is that we cannot specific the date because it change
automatically. I mean you can't determine what date it will be. by this
formular stating 2012,2,24. it won't work. We have to make reference to
whatever date"cell contents" it is according to < , > 90days and more than
the contents of the cell but we never can determine the content of the cell.
Please advice and Thanks once again.

 

[Bernard Liengme]

Then use something like
=$B$1-A1>=90
where B1 is the cell holding the test date