ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   format row of cells to highlight least amount (https://www.excelbanter.com/excel-worksheet-functions/48414-format-row-cells-highlight-least-amount.html)

oceantravel

format row of cells to highlight least amount
 
I need to have the least amount in a row of cells automatically highlight in
a differant color.

JE McGimpsey

One way:

Select the row (say, row 1, with cell A1 the active cell). Choose
Format/Conditional Formatting...

CF1: Formula is =A1=MIN(1:1)
Format1: <patterns/<different color

In article ,
"oceantravel" wrote:

I need to have the least amount in a row of cells automatically highlight in
a differant color.



All times are GMT +1. The time now is 08:50 AM.

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