CONDITIONAL FORMATING
 

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.

CONDITIONAL FORMATING
 

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.

CONDITIONAL FORMATING
 

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.

CONDITIONAL FORMATING
 

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

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


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