Excel - Change row color on condition

December 2016



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.

Related :

This document entitled « Excel - Change row color on condition » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.