| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlight the lowest number - only if it does not equal another va
Thanks for all your help.
"JJ2356" wrote: I want to highlight the lowest number in a range, only if that number does not equal another number in the same range. For instance, if in Cells A1:A6, the number 2 is the lowest number and all other numbers are higher, I want the cell with the number 2 highlighted. If in Cells A1:A6, the number 2 is the lowest number, but occurs twice, I do not want any cells highlighted. Any advice? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Highlight lowest price in a row. | Excel Discussion (Misc queries) | |||
| Highlight highest / lowest number in a row | Excel Discussion (Misc queries) | |||
| highlight lowest value in a list | Excel Discussion (Misc queries) | |||
| CF to highlight lowest price in row | Excel Worksheet Functions | |||
| Highlight lowest number | Excel Discussion (Misc queries) | |||
Threaded Mode
