Tips & Tricks 194 – Highlight Max & Min in your Data Simplified

Create impression on your management. Highlight Maximum and Minimum in your data effortlessly.

Excel file used in this video – https://1drv.ms/x/s!Akd5y6ruJhvhvUYGCzWbpu5BaP2J?e=D57teS

Below are simpler formulas to do this
Across Rows – B2=MAX($B2:$E2), B2=MIN($B2:$E2)
Across Columns – B2=MAX(B$2:B$10), B2=MIN(B$2:B$10)