This is a discussion on highlight cell if date is prior to todays date within the Excel Questions forums, part of the Question Forums category; I want to highlight a cell if the date is before todays date. Cell M3 contains a due date, when ...
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.
Last edited by MWhiteDesigns; Jan 27th, 2012 at 11:23 AM.
If it highlights the whole column, the cond formatting must be set to do that?
If you click on manage rules, what does it say under "applies to"?
Id like to have the cell M3 (due date) , highlighted in red if it passes todays date. In addition if there is a date in N3( completion date) it does not highlight anything.
i thought this might do it. its not working either.
Got your <>'s mixed up again?
Edit - maybe not.....................