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. |
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