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!
Bookmarks