Change Font Color for whole ROW based on 30, 60, 90 days out

[onelovesojah]

The purpose of the spreadsheet is to show by color who is coming up due for their medical examination.

I have the "date of last exam" in column D. The "next exam due date" in column E. Then I have formulas in columns F(30),G(60),H(90) to show the dates that the employee will be 30 days from due date, 60 days and 90 days.

So basically, based on the due date of exam, I want the row to change to ORANGE when they are 60 days out from due date and RED when they are 30 days out from due date. 90 days out can just stay black.

The whole row needs to change color.

Hopefully, that all makes sense and I appreciate any ideas!?

[daffodil11]

Let's pretend the rows start on 3. Yeah.

Highlight row 3.

Conditional Formatting -> Manage Rules -> New Rule... -> Use a Formula Thingy

=(TODAY()-$D4<=30)

Set Fill to Red

New Rule... -> Use a Formula Thingy

=(TODAY()-$D4<=60)

Set Fill to Orange

In Rules Manage Thingy Window, extend 3:3 range for each rule to as many rows as needed.

Be sure Red rule is listed above Orange rule. They can be reordered with the adorable little arrows.
Check the little cute box that says "Stop when True" next to the red one.

The end.

[jjhayes]

This isn't my thread, and I don't post often, but I just had to let Daffodil11 know that I always love his posts. Easy to follow and full of good natured humor.

[onelovesojah]

Thanks.

So I see it can be done, changing the color of a whole row based on a formula.
However, it still isn't doing what I want it to do.

Some dates need to still change to Red and they aren't?
The people who are overdue for an appt. need to change to Red.
The dates that are about 30 days back from today aren't changing.
Also, it seems that dates that are more than 60 days are changing?

I am attaching an example of what I am working with here for a better idea of what I am talking about.

Also, if you look at the very first one. This one should be ORANGE because the date of exam is 60 days away on this date. But it didn't change!?

[daffodil11]

Ahh yes. Just reverse the equations, and make sure red is <.

Red:
=$E2-TODAY()<30

Orange:
=$E3-TODAY()<60

[onelovesojah]

Wow! Thank you!

It worked!