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...
Hello Kyra
Kyra Silbernagel wrote:I know how to apply the rule to each cell individually, but I'm wondering if there's a way to apply it to cells B1:H1 all at once.
No, there isn't.
It's pure logic: For every format you need a separate rule.