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.
