Automatically change colour based on upcoming expiry date.

[John_Fillis]

Hey I am pretty new to this and could use some help.
I am tracking how far out a member is from their Date of release (DOR), I want the cell of the persons name to change to green if they are 91 days + from their DOR; to automatically change to yellow 90-31days from DOR; Red if they are 30 days or less from DOR.

Is this possible?

Thank You,

John

 

[Peter_SSs]

Welcome to the MrExcel board!

Something like this?

24 11 02.xlsm
	A	B	C	D	E
1
2	Name				DOR
3
4	Name 1				20-November-2024
5	Name 2				02-February-2025
6	Name 3				26-November-2024
7	Name 4				11-November-2024
8	Name 5				31-December-2024
9	Name 6				06-February-2025
10	Name 7				08-January-2025
11	Name 8				29-December-2024
12	Name 9				11-November-2024
DOR

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A4:A12	Expression	=E4-TODAY()>=91	text	NO
A4:A12	Expression	=E4-TODAY()>=31	text	NO
A4:A12	Expression	=E4-TODAY()>=0	text	NO

When you enter the Conditional Formatting rules, if the results are not like mine go to Home ribbon tab -> Conditional Formatting -> Manage Rules ...
and use the arrows to ensure the rules appear in the order shown below

BTW, for the future I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with.
(If you have trouble with XL2BB, review the "XL2BB Icons greyed out" link in the 'Known XL2BB issues' section near the top of the XL2BB Instructions page linked above.)