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" wrote:

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.