Error: Excel conditional formatting set on a column but apply on a different column

Occasional Visitor

Hi there,

 

I have a huge pivot table from column A to column QC. It seems there's something wired when setting conditional formatting after column GA. I used Conditional Formatting --> Highlight Cell rules --> More rules --> Select "All cells showing "[Row lables]" value --> then set up the color.

Once I hit ok, it will apply to a column in a front of the table (from my inspection, it's somewhere between column A and GA). Anyone has the same issue? What would be the solution for this? Thank you.

0 Replies