+ Reply to Thread
Results 1 to 3 of 3

Format-Can a cell that is formated for percentage be red if the percentage is negativ

  1. #1
    SteveW
    Guest

    Format-Can a cell that is formated for percentage be red if the percentage is negativ

    Can a cell that is formated for percentage be red if the percentage is
    negative


  2. #2
    Bernard Liengme
    Guest

    re: Format-Can a cell that is formated for percentage be red if the percentage is negativ

    Hi Steve
    1) with custom format 0%;[Red]0%
    OR
    2) using Format |Condition Format; Formula is A1<0 ... format font or
    background to red
    best wishes
    --
    Bernard V Liengme
    www.stfx.ca/people/bliengme
    remove caps from email

    "SteveW" <[email protected]> wrote in message
    news:[email protected]...
    > Can a cell that is formated for percentage be red if the percentage is
    > negative
    >




  3. #3
    Bob Phillips
    Guest

    re: Format-Can a cell that is formated for percentage be red if the percentage is negativ

    Yeah, just set a custom format of

    0%;[Red]0%;0%

    --
    HTH

    Bob Phillips

    (remove nothere from email address if mailing direct)

    "SteveW" <[email protected]> wrote in message
    news:[email protected]...
    > Can a cell that is formated for percentage be red if the percentage is
    > negative
    >




+ 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