Forum Discussion
Conditional formatting applied to many cells separately
Hello, I'm trying to format a group of cells called "bases" (B1:H1) based on if A1 contains a certain letter. For example, if A1 contains an "A", I want B1 to turn yellow. If A1 conta...
Hi Kyra Silbernagel,
Just Go with this.
Select Cell Range "B1:H1"
In Conditional Formatting -> New Rule -> Use a formula to determine which cells to format.
Apply the formula
=SEARCH(B1,$A1,1)>0
Select the Color you want to apply.