ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Conditional Formmating Help (https://www.excelbanter.com/excel-worksheet-functions/203626-conditional-formmating-help.html)

[email protected]

Conditional Formmating Help
 
I have a row of 5 numbers -

I want to highlight the lowest number in the row using conditional
formatting

Help out there?

-Steve

Bob Umlas[_2_]

Conditional Formmating Help
 
If A1:E1 are selected:
=A1=MIN($A1:$E1)
is the formula to use in the conditional formatting dialog...
Adjust accordingly
Bob Umlas
Excel MVP

" wrote in message
...
I have a row of 5 numbers -

I want to highlight the lowest number in the row using conditional
formatting

Help out there?

-Steve




[email protected]

Conditional Formmating Help
 
Perfect Thanks



All times are GMT +1. The time now is 06:36 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com