Hi Jacki,
Conditional formatting is ok. I can give you the process and the formula
but the issue is the today's date.

Now after we have put the conditional format for today, the same excel sheet
may change when you open it tomorrow as the current date changes. Is it ok
for you?

or do you want to mention any specific date for reference.

--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast
Noida, India


"Jacki" wrote:

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!