Conditional format for Highlight first Minimum Value greater than zero

  • Thread starter Thread starter prkhan56
  • Start date Start date
P

prkhan56

Hello All,
I am using Office 2003 and have the following problem
I am trying to use CF to highlight the first Minimum value greater
than zero.

I selected the range with A10 as active cell and used =A10=MIN($A$10:$A
$15) in CF but this highlights Zeros

I also tried =AND(A10>0,MIN($A$10:$A15)) but did not succeed

Can anybody point me in the right direction

TIA

Rashid Khan
 
Hi Rashid,

Try this formula

=A10=MIN(IF($A$10:$A$15<>0,$A$10:$A$15))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Hi Rashid,

Try this formula

=A10=MIN(IF($A$10:$A$15<>0,$A$10:$A$15))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)





Thanks Bob. You are a great help always! Rashid Khan



- Show quoted text -
Click to expand...
 
Back
Top