Highlight Minimum Number > 0 in Red

[Paul Black]

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!

[Tom Ogilvy]

select C7:C1007
with C7 the ActiveCell

format =>Conditional formatting

change cell value is to formula is

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

pay attention to the $ and no $ signs.

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


"Paul Black" <[email protected]> wrote in message
news:u3tlQX%23%[email protected]...
> 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!

[Paul Black]

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!