I'm trying to compare the difference of two cells, and highlight both cells when the difference is more than 50%. I have a field in both the columns and row areas, so it's proving difficult to create the conditional format and then recreate for entire pivot table. Any ideas?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Conditional Format Multiple Cells based on formula (Pivot Table)
- Thread starter MBJOS
- Start date
