Forum Discussion
Solved
Conditional formatting only working on first column
Why does this only apply the formatting to the first column when it says to apply to column B as well?
=$C1="c"You can try this rule for conditional formatting. The dollar sign in front of C1 is the difference.
2 Replies
=$C1="c"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!
