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: =A1DATE(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)-A190
For the yellow condition, Formula Is:
=AND(DATE(2012,2,24)=A1,DATE(2012,2,24)-A1<=90)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Kanmi" wrote in message
...
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.