Highlight Minimum Number 0 in Red
 

Hi Everyone,

I Know this is Probably Simple to do. In the Conditional Format I have
tried the MIN Function, the SMALL Function, a Mixture of BOTH, I have
tried Cell Value Is, Formula Is, Equal To, Greater Than, But to NO
Avail. Can Someone Please Help. I Know I can Adjust the Formula so that
if the Value is Equal to Zero, it will put a Blank "", But this Just
Complicates the Formulas ( and Makes them Less Readable ) and Adds to
the File Size.
I have a Range of Numbers from C7:C1007.
I want to Highlight the Minimum ( Greater Than Zero ) Value in RED (
Background ).

Thanks in Advance
All the Best
Paul

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Highlight Minimum Number 0 in Red
 

select C7:C1007
with C7 the ActiveCell

format =Conditional formatting

change cell value is to formula is

=C7=Min(if($C$7:$C$10070,$C$7:$C$1007))

pay attention to the $ and no $ signs.

then set your pattern and so forth.
--
Regards,
Tom Ogilvy


"Paul Black" wrote in message
...
Hi Everyone,

I Know this is Probably Simple to do. In the Conditional Format I have
tried the MIN Function, the SMALL Function, a Mixture of BOTH, I have
tried Cell Value Is, Formula Is, Equal To, Greater Than, But to NO
Avail. Can Someone Please Help. I Know I can Adjust the Formula so that
if the Value is Equal to Zero, it will put a Blank "", But this Just
Complicates the Formulas ( and Makes them Less Readable ) and Adds to
the File Size.
I have a Range of Numbers from C7:C1007.
I want to Highlight the Minimum ( Greater Than Zero ) Value in RED (
Background ).

Thanks in Advance
All the Best
Paul

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Highlight Minimum Number 0 in Red
 

Brilliant Tom, it Works Great.
All the Best
Paul



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!