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!