Re: Conditional Formatting Colorindex Error In Pivot Table
Reafidy, I did try that as an alternative but it sets the background color, not the font color to red.
Dave, here's the funny part. I did that and the recorded macro won't work on the same thing. ::D The recorded macro yields me about the same kind of code as I currently have. Could it be something to do with the pivot? I tested the code on a "regular" range and it worked just fine!
I suppose an alternative is to "manually" treat the rows as a regular range and see if that works?