In pivot table using conditional formatting I want to highlight values where percent difference is more than -50%(i.e., -70%,-60%,…)
I don’t want to highlight -5%,-22%.
Anything above -50% I should highlight.
Max
2
You would do your second filter.
Less than -.5 would be anything more than -50%
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Conditional Formatting Not Working On % Value | 1 | 246 | August 24, 2023 | |
| Pivot Conditional Formatting based on another value | 3 | 293 | October 31, 2023 | |
| How set background of cell depending on the thresold value in Pivot Table | 2 | 56 | March 25, 2025 | |
| Add conditional formatting for each row as target value for each row is different | 1 | 276 | July 20, 2023 | |
| How to color the values of the table based on the condition on rows and columns | 15 | 1597 | May 15, 2024 |