| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Conditional formatting lowest number greater than zero
I need to conditionally format b26:u42 to find lowest number that is greater than zero. Thank you
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional formatting lowest number greater than zero
Hi Mitch,
Am Mon, 17 Nov 2014 22:26:31 +0000 schrieb mitch71111: I need to conditionally format b26:u42 to find lowest number that is greater than zero select B26:U42 = CF = Formula to determine.... =B26=SMALL($B$26:$U$42,COUNTIF($B$26:$U$42,0)+1) Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional format lowest value greater than zero and copy formula | Excel Discussion (Misc queries) | |||
| lowest number in a row that is greater than zero | Excel Discussion (Misc queries) | |||
| lowest number in a row that is greater than zero | Excel Discussion (Misc queries) | |||
| Conditional formatting for lowest number in a string | Excel Worksheet Functions | |||
| Conditional Formatting lowest # if it only appears once | Excel Worksheet Functions | |||
Linear Mode
