No Daniel, actually, I am using Excel 2003. Thanks anyway Daniel - I do
appreciate your efforts. Jacki

"Daniel.C" wrote:

I assumed you wanted to use the stop lights of XL2007 conditional
format. If it's not the case, please forget my answer. This formatting
is based on the values of the cell, so you have to enter the formula in
the cell to which you want to apply a conditional formatting.
Daniel

Daniel,

Thank you for your reply and your help- and please forgive my ignorance: is
this whole formula pasted into one condition, or is this the formula for all
three conditions? If so, where is the break for the other conditions?
Please advise, and in the meantime, I'm going to try to work it.

"Daniel.C" wrote:

Paste the following formula in the cell you want to format :
=IF(AND(F2<TODAY(),H2-F245),3,IF(AND(F2TODAY(),H2-F2<45),2,IF(F2=TODAY(),1,0)))
In the conditional format, choose the spotlights, modify the rule :
Green if value =3, yellow if value =2, else red.
HTH
Daniel

I need help - I am trying to set up conditional formatting to show status
using the red, green and yellow "Stop Light". I have three conditions, but
I am having troubles setting the formulas for them.

1. For the 1st condition, I want to show that if the action (Cell F2) is
progressing beyond today, and is less than 45 days before the target
completion date (Cell H2), then it is GREEN

2. For the 2nd, it would be if the action in cell F2 is greater than today,
but within 45 days from the target completion date in Cell H2, then it
would be yellow

3. For the 3rd, it the action in Cell F2 is equal to or greater than today,
then it would be red.

Someone please tell me how to set these formats - I could tell you what I
have, but it would not be pretty - I need help for a school project.
Thanks!