NoelD
New Member
- Joined
- Apr 16, 2015
- Messages
- 34
- Office Version
- 2019
- Platform
- Windows
Hi All
I am seeking help in creating some additional conditional formatting on the attached spreadsheet.
I have an "ALERT" traffic light "RED" when the current mileage exceeds the Scheduled Mileage. It is "AMBER" if with 1500 km and GREEN when outside this.
I would like to incorporate the Scheduled Date versus TOday into the RED alert; an AMBER alert when it's 30 days away from the Schedule date and GREEN outside of these dates.
Is this possible in the one ALERT column
Regards
Noel
I am seeking help in creating some additional conditional formatting on the attached spreadsheet.
I have an "ALERT" traffic light "RED" when the current mileage exceeds the Scheduled Mileage. It is "AMBER" if with 1500 km and GREEN when outside this.
I would like to incorporate the Scheduled Date versus TOday into the RED alert; an AMBER alert when it's 30 days away from the Schedule date and GREEN outside of these dates.
Is this possible in the one ALERT column
Regards
Noel
|