Expiration Date to trigger row to change color

[dreday383]

Hello all,
I have search for the proper formula but haven't found a complete fix. What I am doing is creating a spread sheet for certifications with expiration dates. I need the expiration dates to trigger the whole row to turn yellow, amber and red for 30 days, 60 days, and 90 days before the expiration date. IDK if that communicates properly. I found this =AND(E6<=TODAY()+30,E6<>"") in the search engine but this formula only changes the first cell the I highlighted. I need it to trigger the whole row to turn a color. Thank you very much.

[6StringJazzer]

First, if the date is in column E then your formula should be

=AND($E6<=TODAY()+30,$E6<>"")

Second, make sure the Applies To range includes the entire row.

[63falcondude]

Hello and welcome to the forum.

If you want Conditional Formatting to produce three different colors, you have to create three CF rules in this order (one for each color).

Yellow:
Highlight the entire area that you want to apply the conditional formatting to (e.g. E6:Z100) > Conditional Formatting > New Rule > Use a formula
=AND($E6<>"",$E6-TODAY()<=90)
Format: Fill Yellow > OK > OK

Amber:
Highlight the entire area that you want to apply the conditional formatting to (e.g. E6:Z100) > Conditional Formatting > New Rule > Use a formula
=AND($E6<>"",$E6-TODAY()<=60)
Format: Fill Amber > OK > OK

Red:
Highlight the entire area that you want to apply the conditional formatting to (e.g. E6:Z100) > Conditional Formatting > New Rule > Use a formula
=AND($E6<>"",$E6-TODAY()<=30)
Format: Fill Red > OK > OK

[dreday383]

63falcondude,

This work perfect! Exactly what I was looking for thank you so much.