How to Highlight the Highest and Lowest Value in Each Row or Column in Excel

preview_player
Показать описание
This video will guide you how to highlight the highest value in each row or column in Excel. How do I highlight the lowest value in each row and column with conditional formatting function.

#########
#########
Рекомендации по теме
Комментарии
Автор

My value is in currency and I have Na values in certain cells.does it matter?, i applied the rule but nothing was highlighted.

florlim
Автор

Hi, how will be TOP2 or TOP3? (instead of MAX )

RafeeQueMohammedRefi
welcome to shbcf.ru