MWhiteDesigns
Well-known Member
- Joined
- Nov 17, 2010
- Messages
- 646
- Office Version
- 2016
- Platform
- Windows
I want to highlight a cell if the date is before todays date.
Cell M3 contains a due date, when it passes the date it needs to turn red. I'm using the code below but it highlights the whole column. I'd like it to leave everything untouched until the date is passed.
<TODAY()[ p CODE]<>
Cell M3 contains a due date, when it passes the date it needs to turn red. I'm using the code below but it highlights the whole column. I'd like it to leave everything untouched until the date is passed.
Code:
=$M$3<TODAY()< p> < TODAY()
Last edited: