Backgrounds

[Doss53]

I have been lookin and haven’t come across what I am wanting to do I have a spreadsheet with all of my shop computers and the dates that software expire. I want the backgrounds to be green while the dates are good. When it gets within 30 days I want it to be yellow or orange and turn red the day of the expiration

 

[etaf]

use conditional formatting
and use various formula rules
if dates from b2


green
=b2>today()+30

yellow
=AND(B2>TODAY(),B2<=TODAY()+30)

red
=B2<=TODAY()

Unknown 64 bit
	B
2	1/1/18
3	2/1/18
4	3/1/18
5	4/1/18
6	5/1/18
7	6/1/18
8	7/1/18
9	8/1/18
10	9/1/18
11	10/1/18
12	11/1/18
13	12/1/18
14	1/1/19
15	2/1/19
16	3/1/19
17	4/1/19
18	5/1/19
19	6/1/19
20	7/1/19
21	8/1/19
22	9/1/19
23	10/1/19
24	11/1/19
25	12/1/19
26	1/1/20
Sheet1