0
Thanks

A few words of thanks would be greatly appreciated.

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.
0
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
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

Original article published by . Translated by aakai1056. Latest update on by Olivia Long.

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/).

0 Comments