conditional formatting

I have an excel sheet that lists “product must be returned by date, column M” and “product returned date, column N”

What I need to happen is any date in column M that is less than todays date I need to hightlighted RED.  

However, if the cell in column N has a value (a date) in it then I need column M to ignore formating and not be highlighted in RED.

I also need if the cell in column N is blank and M is blank then they need no formatting.

By: Erin

Leave a Reply

Your email address will not be published. Required fields are marked *