Jun 30 2022 08:47 AM
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 want, and quite frankly, it appears random. Here are the steps I have taken
1. make my selection (columns A-K, Rows 2-47)
2. Conditional Formatting > New Rule...
3. "Use a formula to determine which cells to format"
4. =SEARCH("Ridgestone",E2), Format... > fill (Yellow Highlight)
Jun 30 2022 08:52 AM
Jun 30 2022 08:56 AM
Jun 30 2022 09:19 AM
=SEARCH("Ridgestone",$E1)
=$A$1:$K$46
Now 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.