Excel: Highlight the Highest and Lowest Values in a Pivot Table Row
This video is in response to a viewer's question "is there a way to highlight the highest and lowest values in a pivot table row?". In the video I cover 2 methods to do this, both using Conditional Formatting. The result is that the highest value in each row is displayed with a green background and the lowest value in each row has a red background.
🗒 Notes and Resources
Download a copy of the file used in this video: https://app.box.com/s/m3yecm484kc6mnx...
The formulas that I used in the demos:
=B3=MAX($B3:$H3) to find the highest value in the row
=B3=MIN($B3:$H3) to find the lowest value in the row.
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #conditionalformatting #pivottable