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

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