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

Related

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 (ccm.net).

0 Comments