Conditional formatting

[lcykoax]

Hi!

I currently have a conditional formatting formula to highlight a row if column S is "YES". That's done.

If column T contains a text or value, I would need the row to change its color from red to yellow to determine that an invoice has been generated.

Once invoice has been paid, and a date appears on column Y, and I would need that color to be green.

Is there a way to do this?

[TMS]

For red:

=$S2="YES"

For amber:

=AND($S2="YES", $T2<>"")

For green:

=AND($S2="YES", $T2<>"", $Y2<>"")

[lcykoax]

Thanks a bunch!

[TMS]

You're welcome. Thanks for the rep.