karthickerfolg
New Member
- Joined
- Apr 18, 2021
- Messages
- 3
- Office Version
- 2019
- Platform
- Windows
Dear Forum members,
I want to do a conditional formatting on the actual date to show if the actual date -planned date is less than or equal to 3, the actual date cell should be green, anything between 4 to 10, it should be yellow and anything more than 10 it should be red. I could not do it. Could you all please help?
I want to do a conditional formatting on the actual date to show if the actual date -planned date is less than or equal to 3, the actual date cell should be green, anything between 4 to 10, it should be yellow and anything more than 10 it should be red. I could not do it. Could you all please help?
SCHEDULE | Start date |
Planned | 3-Sep-21 |
Actual | |
Planned | 12-Oct-21 |
Actual | |
Planned | 1-Dec-21 |
Actual |