+ Reply to Thread
Results 1 to 3 of 3

Highlight Minimum Number > 0 in Red

  1. #1
    Paul Black
    Guest

    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!

  2. #2
    Tom Ogilvy
    Guest

    Re: 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$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!




  3. #3
    Paul Black
    Guest

    Re: 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!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1