Conditional formatting only working on first column

Copper Contributor

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


Screenshot 2023-05-22 at 17.15.31.png


Screenshot 2023-05-22 at 17.16.20.png


2 Replies
best response confirmed by jamie1010 (Copper Contributor)



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

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!