Forum Discussion
How can I use Pivot Table References for Conditional Formatting?
Hello! I have a pivot table where the following columns are repeated for several states, so the easiest way to create the conditional formatting would be one that works for the entire pivot table...
Perhaps the attached example is similar to what you are looking for. I've entered a rule for conditional formatting based on two columns.
- Thanks, Oliver. I'm hesitant to download an unknown file; would you mind copying in your conditional formatting rule as text in a response so I can get the general idea and help inform the decision to download your file or not?
Hi LMercury,
this is the rule for conditional formatting.
=(H2>180000)*(I2>12000000)
And here's a screenshot of the file. I assume that without seeing the screenshot the rule wouldn't be helpful.
