CODEWITHSUNDEEP
excel
Schillerlocke
Schillerlocke

Reputation: 343

Excel - condtional formatting based on multiple strings

I would like to fill the cells individually from C to L based on the 7 lists on the right. Unfortunately this isn't working too well.

Not every cell is getting filled and others are filled wrong/double.

I select the cells for the conditional formatting for the deep red list based on this:

=OR(ISNUMBER(SEARCH($M$2:$M$20; C2)))

I'd guess that here's a simple error in thought with the "C2"?. Thanks in advance!

enter image description here

Edit:

Link to the file https://drive.google.com/open?id=1mtGdSlDCMdR1qXVU07Z-hGFyvtq21Hpb

Upvotes: 1

Views: 84

Answers (1)

Professor Pantsless
Professor Pantsless

Reputation: 484

The conditional format rule you are using applies to the range $C:$L. The first cell in this range is C1; substitute C2 in your formula with C1 and it should work as desired.

Upvotes: 1

Related Questions