Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Get a row number of range where a value is between minimum and max | Excel Worksheet Functions | |||
How to get the minimum number of one column while ignoring the err | Excel Discussion (Misc queries) | |||
Minimum highlight | Excel Worksheet Functions | |||
Conditional format of minimum number | Excel Worksheet Functions | |||
How do I sum a number of columns and ignore the minimum value? | Excel Discussion (Misc queries) |