Confitional Formatting using (Red/Yellow/Green) for due dates
 

If your exp. dates are in column A, then
formula for red: A2<Today()
for yellow: A2<Today()+30
for green: A2<Today()+30

Regards,
Stefi

€žInward-Smile(Meka)€� ezt Ã*rta:

Hey,
Need help with the following problem, hope someone can help. see below:
I'm created a spreadsheet with a column for "Employee Driver's License Exp.
Dates". I want to setup a rules that format certain cells to be highlighted
in red, when they expire anytime before today's date.
Second, I want to highlight cells "Yellow", if the date within a cell is
within 30 days of the expiration date.
Lastly, and third, I would like to highlight cells "Green", if the cell's
date is within 60 days of expiration.
Any suggestions or explicit, detailed instructions would be greatly
appreciated. I tried the Demo in Microsoft Excell 2003, but I ended up
making all my cells "Red"! Yeesh
Please help :)

Confitional Formatting using (Red/Yellow/Green) for due dates
 

Sorry, for green of course A2<Today()+60
Stefi


€žStefi€� ezt Ã*rta:

If your exp. dates are in column A, then
formula for red: A2<Today()
for yellow: A2<Today()+30
for green: A2<Today()+30

Regards,
Stefi

€žInward-Smile(Meka)€� ezt Ã*rta:

Hey,
Need help with the following problem, hope someone can help. see below:
I'm created a spreadsheet with a column for "Employee Driver's License Exp.
Dates". I want to setup a rules that format certain cells to be highlighted
in red, when they expire anytime before today's date.
Second, I want to highlight cells "Yellow", if the date within a cell is
within 30 days of the expiration date.
Lastly, and third, I would like to highlight cells "Green", if the cell's
date is within 60 days of expiration.
Any suggestions or explicit, detailed instructions would be greatly
appreciated. I tried the Demo in Microsoft Excell 2003, but I ended up
making all my cells "Red"! Yeesh
Please help :)

Confitional Formatting using (Red/Yellow/Green) for due dates
 

Hi Stefi,
Thanks for responding to my post. I input the above information but nothing
happened. For example, a one cell contained "8/3/2009", yet it did not have
the "Red" color highlight or any color within the cell. Is there something
else I'm missing



"Stefi" wrote:

Sorry, for green of course A2<Today()+60
Stefi


€žStefi€� ezt Ã*rta:

If your exp. dates are in column A, then
formula for red: A2<Today()
for yellow: A2<Today()+30
for green: A2<Today()+30

Regards,
Stefi

€žInward-Smile(Meka)€� ezt Ã*rta:

Hey,
Need help with the following problem, hope someone can help. see below:
I'm created a spreadsheet with a column for "Employee Driver's License Exp.
Dates". I want to setup a rules that format certain cells to be highlighted
in red, when they expire anytime before today's date.
Second, I want to highlight cells "Yellow", if the date within a cell is
within 30 days of the expiration date.
Lastly, and third, I would like to highlight cells "Green", if the cell's
date is within 60 days of expiration.
Any suggestions or explicit, detailed instructions would be greatly
appreciated. I tried the Demo in Microsoft Excell 2003, but I ended up
making all my cells "Red"! Yeesh
Please help :)

Confitional Formatting using (Red/Yellow/Green) for due dates
 

First question: are you sure that you've got real dates, rather than text?
What do =ISTEXT(A2) and =ISNUMBER(A2) return? What does your 8/3/2009 show
if you temporarily format the cell as General instead of date?
Secondly, exactly what do you have in the "Formula Is" field in Conditional
Formatting? Copy your formula from that field and paste it here. Stefi
forgot the = signa at the start of the formula, so there is a danger than
Excel will have thought you were defining a text string and put quote marks
around your formula.
--
David Biddulph

"Inward-Smile(Meka)" wrote in
message ...
Hi Stefi,
Thanks for responding to my post. I input the above information but
nothing
happened. For example, a one cell contained "8/3/2009", yet it did not
have
the "Red" color highlight or any color within the cell. Is there
something
else I'm missing



"Stefi" wrote:

Sorry, for green of course A2<Today()+60
Stefi


"Stefi" ezt írta:

If your exp. dates are in column A, then
formula for red: A2<Today()
for yellow: A2<Today()+30
for green: A2<Today()+30

Regards,
Stefi

"Inward-Smile(Meka)" ezt írta:

Hey,
Need help with the following problem, hope someone can help. see
below:
I'm created a spreadsheet with a column for "Employee Driver's
License Exp.
Dates". I want to setup a rules that format certain cells to be
highlighted
in red, when they expire anytime before today's date.
Second, I want to highlight cells "Yellow", if the date within a cell
is
within 30 days of the expiration date.
Lastly, and third, I would like to highlight cells "Green", if the
cell's
date is within 60 days of expiration.
Any suggestions or explicit, detailed instructions would be greatly
appreciated. I tried the Demo in Microsoft Excell 2003, but I ended
up
making all my cells "Red"! Yeesh
Please help :)