Forum Discussion
Solved
Conditional formatting help
Hi, Can someone help explain why the conditional formatting formula is not working? I am highlighting column K to apply a conditional format to ensure the font turns red if the following formula ...
Amy86 When you apply CF to an entire column, you need to point to A1 and K1 in the AND function.
Alternatively, change the applied range to $K$2:$K$20000 or somethin large enough to capture all your data.
Amy86 When you apply CF to an entire column, you need to point to A1 and K1 in the AND function.
Alternatively, change the applied range to $K$2:$K$20000 or somethin large enough to capture all your data.
- Ah - it was that simple.
Thank you so much 🙂
