View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default 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