Conditional formatting only working on first column

[jamie1010]

Why does this only apply the formatting to the first column when it says to apply to column B as well?

[#2 · Accepted solution]

@jamie1010 

=$C1="c"

You can try this rule for conditional formatting. The dollar sign in front of C1 is the difference.

[#3]

Ah I get it, because the area it applies to is multiple columns it’s also moving the condition as well rather than sticking on column C. Thank you!