| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Highlight lowest number
Can you select a range and have the lowest number automatically be
highlighted in red? thanks! |
|
#2
|
|||
|
|||
|
1. Select the range and name it "myrange" (no quotes).
Press Ctrl+F3 or go to Insert Name Define. 2. Go to Format Conditional Formatting. 3. Select "Formula Is" and put: =INDIRECT("rc",0)=MIN(myrange) 4. Press the "Format" radio button and format as desired. HTH Jason Atlanta, GA -----Original Message----- Can you select a range and have the lowest number automatically be highlighted in red? thanks! . |
|
#3
|
|||
|
|||
|
Why not just use the address directly for the activecell?
Select the range (say B12:F92) and with B12 the activecell: format|conditional formatting formula is: =b12=min($b$12:$f$92) (using the range name would still work and may be easier to decipher later.) Jason Morin wrote: 1. Select the range and name it "myrange" (no quotes). Press Ctrl+F3 or go to Insert Name Define. 2. Go to Format Conditional Formatting. 3. Select "Formula Is" and put: =INDIRECT("rc",0)=MIN(myrange) 4. Press the "Format" radio button and format as desired. HTH Jason Atlanta, GA -----Original Message----- Can you select a range and have the lowest number automatically be highlighted in red? thanks! . -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| Number of Column Limitations | Excel Discussion (Misc queries) | |||
| Adding + in front of a number | Excel Discussion (Misc queries) | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
Linear Mode
