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