Excel - Change row color on condition


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.
Published by aakai1056. Latest update on February 25, 2018 at 06:56 PM by owilson.
This document, titled "Excel - Change row color on condition," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (https://ccm.net/).
Excel - Add a suffix or prefix
Macro to Compare two sheet with both sheets