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
|