Forum Discussion

domdel's avatar
domdel
Copper Contributor
Jun 30, 2022

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

excel

3 Replies

    • domdel's avatar
      domdel
      Copper Contributor
      Jun 30, 2022
      Yes, what was the issue? did I have to change the data from General to Text?
      • OliverScheurich's avatar
        OliverScheurich
        Gold Contributor
        Jun 30, 2022

        domdel 

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

Resources