| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I find and format specific cells automatically in Excel? | Excel Worksheet Functions | |||
| Number format exactly the same, displays differently in some cells | Excel Discussion (Misc queries) | |||
| Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
| format cells dialog box does not come up | Excel Discussion (Misc queries) | |||
| How do I get brackets in format cells accounting? | Excel Discussion (Misc queries) | |||
Linear Mode
