Using condition formatting, I am trying to change the colour of cell based on a date.

Microsoft Windows

Microsoft Windows

Active Members
Joined
Dec 10, 2024
Messages
11,924
Using condition formatting, I am trying to change the colour of a cell based on a date. The idea is that if a training certificate expires in 2 months the cell will turn green.If the training certificate expires in 1 month time the cell will turn yellow.If the training certificate has expired the cell will turn red.Like a traffic light system.I am using the following formulas:=AND(C6:AY25>(TODAY()+30),C6:AY25<(TODAY()+60))to turn green=AND(C6:AY25>TODAY(),C6:AY25<=(TODAY()+30))to turn yellowBut they are not working.And I can't figure out the final formula to turn t

Continue reading...
 
You must log in or register to reply here.

Similar threads

Windows Server
Using condition formatting, I am trying to change the colour of cell based on a date.
Replies
0
Views
3
Windows Server
Windows Server
A
I can't change the date of birth on my account. It's somehow entered 2019 as the birth year and I've tried to add the account to a family account to c
Replies
0
Views
11
Aalia Mubarik
A
G
I created my accounts using the current date instead of a birth date, how to change the date?
Replies
0
Views
6
good chem
G
G
I created my accounts using the current date instead of a birth date, how to change the date?
Replies
0
Views
13
good chem
G
A
I am trying to sign into my account on my PC but it says the pin was reset due to a security change and I need to make a new one.
Replies
0
Views
21
Andrew Blondeau
A
Back
Top