I'm trying to do a conditional format for license expiration dates. If it is expired (past today's date), it needs to be red. If it is expiring within the next 90 days, yellow, and good for 90 or more days, green. Any help would be appreciated.
I'm trying to do a conditional format for license expiration dates. If it is expired (past today's date), it needs to be red. If it is expiring within the next 90 days, yellow, and good for 90 or more days, green. Any help would be appreciated.
Hello and welcome to the forum.
This will require 3 conditional formatting formulas (one for each color).
Let's say that the license expiration days are in column A starting in A2. Apply the following rules in this order:
Green
Highlight A2:A100 (or however far your data goes) > Conditional Formatting > New Rule > Use a formula
=A2-TODAY()>=90
Format: Fill green > OK > OK
Yellow
Highlight A2:A100 (or however far your data goes) > Conditional Formatting > New Rule > Use a formula
=A2-TODAY()<90
Format: Fill yellow > OK > OK
Red
Highlight A2:A100 (or however far your data goes) > Conditional Formatting > New Rule > Use a formula
=TODAY()>A2
Format: Fill red > OK > OK
If there can be blank cells in the column, you can use this as the red formula:
=AND(TODAY()>A2,A2<>"")
and this for yellow:
=AND(A2-TODAY()<90,A2<>"")
Last edited by 63falcondude; 03-29-2018 at 12:59 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks