Excel - Change row color on condition

Ask a question

Issue

I have dates in column M and Column N. I want each row to to change color if either Column M or Column N has a value = to today.

I need help with the syntax.

Solution

Try this:
  • Highlight your rows (say 10 to 20)
  • Go to the conditional format box
  • Set the control to "Formula is"
  • Enter this formula: =OR($M10=TODAY(),$N10=TODAY())
  • Set your color / font etc as desired and press Enter/OK

Note that

Thanks to AusSteelMan for this tip on the forum.
Jean-François Pillou

CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jeff Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Learn more about the CCM team