Forum Discussion
Conditional Formatting Error - selecting partial text, highlighting wrong rows (at random)
Hi All, I downloaded a report into CSV for various properties. I wanted to highlight entire row if the property name contained a partial text. However, it's highlighting rows EXCEPT the ones I w...
Yes, what was the issue? did I have to change the data from General to Text?
=SEARCH("Ridgestone",$E1)=$A$1:$K$46Now the rule for conditional formatting and the "applies to" range both start in row1.
Before the rule for conditional formatting started in row 2.
=SEARCH("Ridgestone",$E2)The "applies to" range didn't change and therefore the formatting was shifted by 1 row.