+ Reply to Thread
Results 1 to 3 of 3

conditionally format cells

  1. #1
    elad
    Guest

    conditionally format cells

    I have a cell that contains a formula that can yield either a dollar value or
    a percentage value, depending on inputs. How can I format the cell to
    correctly match the result?

  2. #2
    Jason Morin
    Guest

    RE: conditionally format cells

    If the percent is never greater than 100%, then you could custom format the
    font color. For example:

    [Red][<1]0%;[Blue]$#.00

    HTH
    Jason
    Atlanta, GA





    "elad" wrote:

    > I have a cell that contains a formula that can yield either a dollar value or
    > a percentage value, depending on inputs. How can I format the cell to
    > correctly match the result?


  3. #3
    RagDyeR
    Guest

    Re: conditionally format cells

    Since you didn't state examples, try this custom format, where you'll
    *never* have a return of 100%:

    [>=1]$#,###.00;[<1]#.0%;General

    If you anticipate a return of 100%, try this, where you'll lose the ability
    to display $1:

    [>1]$#,###.00;[<=1]#.0%;General
    --

    HTH,

    RD
    ==============================================
    Please keep all correspondence within the Group, so all may benefit!
    ==============================================


    "elad" <elad@discussions.microsoft.com> wrote in message
    news:522E790D-F188-44CA-9214-F456E4C4BB36@microsoft.com...
    I have a cell that contains a formula that can yield either a dollar value
    or
    a percentage value, depending on inputs. How can I format the cell to
    correctly match the result?



+ 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