Forum Discussion
Conditional Formatting
Hello, I am developing a conditional formatting rule that allows me to enter a specific text value, and if it matches the content of another cell, that cell will be highlighted in green. However, instead of highlighting only the matching cell, the entire selected range is being highlighted each time I enter a text value.
1 Reply
This is the rule for conditional formatting in the attached sample file.
=E2=$N$2This is the "applies to" range.
=$E$2:$K$15All exactly matching cells within the applies to range are highlighted.
