theguyIsHere
New Member
- Joined
- Oct 2, 2013
- Messages
- 19
- Office Version
- 2019
- Platform
- MacOS
How do I get the finish date column to be highlighted in Red based on the following criteria, please:
- If the date is in the past (AND)
- status does not equal 'Complete', 'on hold' ?
I can do conditional formatting for the date but not the second item Many thanks
- If the date is in the past (AND)
- status does not equal 'Complete', 'on hold' ?
I can do conditional formatting for the date but not the second item Many thanks
Project Name | Finish Date | Project Status |
---|---|---|
Project 1 | 20 Oct 2022 | Complete |
Project 2 | 30 Sep 2022 | Red |
Project 3 | 15 Dec 2022 | Green |