1. You are viewing our forum as a guest. For full access please Register. WindowsBBS.com is completely free, paid for by advertisers and donations.

98SE/Excel2000/Numeric Data

Discussion in 'Other PC Software' started by merlin, 2003/12/24.

Thread Status:
Not open for further replies.
  1. 2003/12/24
    merlin

    merlin Inactive Thread Starter

    Joined:
    2003/01/07
    Messages:
    1,111
    Likes Received:
    0
    Hi all !
    (A2-A1) goes in A3. All cells are numeric format.
    If A3 is positive, this cell should show an unsigned number
    with a font/color I choose. Maybe a custom color.
    If A3 is negative, this cell should show an unsigned number
    with a font/color I choose. Maybe a custom color.
    In A3 I do not want leading zeros or decimals and no sign.
    How to format cell A3 ?
    Looked at Excel Help, and tried conditional formatting and
    the [Red]#;[Green]#;[Green]# variations, but get colors I do
    not want - what are Excel's color definition codes ?
    Eg is there a [Darkgreen] - I do not think so.
    Any help much appreciated ...
    regards
     
    Last edited: 2003/12/24
  2. 2003/12/24
    Newt

    Newt Inactive

    Joined:
    2002/01/07
    Messages:
    10,974
    Likes Received:
    2
    Green doesn't have many variations and the darkest (green as opposed to sea green , bright green, etc.) isn't very dark. Lots more options with blue.

    There is a color labeled Dark Green but my display at work (Intel 82845G) displays it as sort of a light black.
     
    Newt,
    #2

  3. to hide this advert.

  4. 2003/12/25
    merlin

    merlin Inactive Thread Starter

    Joined:
    2003/01/07
    Messages:
    1,111
    Likes Received:
    0
    Thanks Newt, where do I find the color labels that Excel
    recognises ?
    regards
     
  5. 2003/12/25
    merlin

    merlin Inactive Thread Starter

    Joined:
    2003/01/07
    Messages:
    1,111
    Likes Received:
    0
    Found how to do this - thanks for help.
    regards
    PS Excel only knows 8 basic colors, but with the cell formatting
    you can set a conditioned cell font to a color of choice.
     
Thread Status:
Not open for further replies.

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.