+ Reply to Thread
Results 1 to 26 of 26

How to make the cell or font color red if the number is negative?

  1. #1
    Bob T
    Guest

    How to make the cell or font color red if the number is negative?

    I'd like to make a cell change color or the cell's font change color as the
    number in the cell changes from negative to positive or vice versa?

  2. #2
    Bob Phillips
    Guest

    Re: How to make the cell or font color red if the number is negative?

    Use conditional formatting with a condition of less than 0.

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "Bob T" <Bob T@discussions.microsoft.com> wrote in message
    news:995EE172-AAE8-46EE-ADB4-5DF46F9D3806@microsoft.com...
    > I'd like to make a cell change color or the cell's font change color as

    the
    > number in the cell changes from negative to positive or vice versa?




  3. #3
    Max
    Guest

    Re: How to make the cell or font color red if the number is negative?

    Try Conditional Formatting

    Suppose you want this to happen in say, col E
    Select col E
    Click Format > Conditional Formatting
    Make the settings as:

    For Condition 1:
    Formula Is| =AND(E1<>"",ISNUMBER(E1),E1>=0)
    Click Format button > Patterns tab > Light green? > OK

    Click Add

    For Condition 2:
    Formula Is| =AND(E1<>"",ISNUMBER(E1),E1<0)
    Click Format button > Patterns tab > Pink? > OK

    Click OK at the main dialog

    Now test it out by inputting some negative, positive values, zeroes and some
    text (e.g.: "ABC") in col E ..

    The cells' fill color should appear accordingly for the numbers, any cell
    with text entered or empty cells should not trigger the C.F. (i.e. no
    formatting should occur)
    --
    Rgds
    Max
    xl 97
    ---
    GMT+8, 1° 22' N 103° 45' E
    xdemechanik <at>yahoo<dot>com
    ----
    Bob T <Bob T@discussions.microsoft.com> wrote in message
    news:995EE172-AAE8-46EE-ADB4-5DF46F9D3806@microsoft.com...
    > I'd like to make a cell change color or the cell's font change color as

    the
    > number in the cell changes from negative to positive or vice versa?




  4. #4
    Bob T
    Guest

    Re: How to make the cell or font color red if the number is negati

    Thanks Bob! That's exactly what I was looking for

    "Bob Phillips" wrote:

    > Use conditional formatting with a condition of less than 0.
    >
    > --
    >
    > HTH
    >
    > RP
    > (remove nothere from the email address if mailing direct)
    >
    >
    > "Bob T" <Bob T@discussions.microsoft.com> wrote in message
    > news:995EE172-AAE8-46EE-ADB4-5DF46F9D3806@microsoft.com...
    > > I'd like to make a cell change color or the cell's font change color as

    > the
    > > number in the cell changes from negative to positive or vice versa?

    >
    >
    >


  5. #5
    Bob T
    Guest

    Re: How to make the cell or font color red if the number is negati

    Thanks Max! Your answer was very helpful, exactly what I wanted.

    "Max" wrote:

    > Try Conditional Formatting
    >
    > Suppose you want this to happen in say, col E
    > Select col E
    > Click Format > Conditional Formatting
    > Make the settings as:
    >
    > For Condition 1:
    > Formula Is| =AND(E1<>"",ISNUMBER(E1),E1>=0)
    > Click Format button > Patterns tab > Light green? > OK
    >
    > Click Add
    >
    > For Condition 2:
    > Formula Is| =AND(E1<>"",ISNUMBER(E1),E1<0)
    > Click Format button > Patterns tab > Pink? > OK
    >
    > Click OK at the main dialog
    >
    > Now test it out by inputting some negative, positive values, zeroes and some
    > text (e.g.: "ABC") in col E ..
    >
    > The cells' fill color should appear accordingly for the numbers, any cell
    > with text entered or empty cells should not trigger the C.F. (i.e. no
    > formatting should occur)
    > --
    > Rgds
    > Max
    > xl 97
    > ---
    > GMT+8, 1° 22' N 103° 45' E
    > xdemechanik <at>yahoo<dot>com
    > ----
    > Bob T <Bob T@discussions.microsoft.com> wrote in message
    > news:995EE172-AAE8-46EE-ADB4-5DF46F9D3806@microsoft.com...
    > > I'd like to make a cell change color or the cell's font change color as

    > the
    > > number in the cell changes from negative to positive or vice versa?

    >
    >
    >


  6. #6
    Max
    Guest

    Re: How to make the cell or font color red if the number is negati

    You're welcome, Bob !
    Thanks for the feedback
    --
    Rgds
    Max
    xl 97
    ---
    GMT+8, 1° 22' N 103° 45' E
    xdemechanik <at>yahoo<dot>com
    ----
    "Bob T" <Bob T@discussions.microsoft.com> wrote
    > Thanks Max! Your answer was very helpful, exactly what I wanted.




  7. #7
    RODY
    Guest

    RE: How to make the cell or font color red if the number is negative?

    HI BOB TRY USING CONDITIONAL FORMATING GO TO TOOLS MENU / CONDITIONAL
    FORMATING / CELL VALUE IS / NOT EQUAL TO / TYPE 0 / CLICK FORMAT / CLICK THE
    BUTTON WOULD YOU LIKE TO DO

    "Bob T" wrote:

    > I'd like to make a cell change color or the cell's font change color as the
    > number in the cell changes from negative to positive or vice versa?


  8. #8
    RODY
    Guest

    RE: How to make the cell or font color red if the number is negative?

    HI BOB TRY USING CONDITIONAL FORMATING GO TO TOOLS MENU / CONDITIONAL
    FORMATING / CELL VALUE IS / NOT EQUAL TO / TYPE 0 / CLICK FORMAT / CLICK THE
    BUTTON WOULD YOU LIKE TO DO

    "Bob T" wrote:

    > I'd like to make a cell change color or the cell's font change color as the
    > number in the cell changes from negative to positive or vice versa?


  9. #9
    RODY
    Guest

    RE: How to make the cell or font color red if the number is negative?

    HI BOB TRY USING CONDITIONAL FORMATING GO TO TOOLS MENU / CONDITIONAL
    FORMATING / CELL VALUE IS / NOT EQUAL TO / TYPE 0 / CLICK FORMAT / CLICK THE
    BUTTON WOULD YOU LIKE TO DO

    "Bob T" wrote:

    > I'd like to make a cell change color or the cell's font change color as the
    > number in the cell changes from negative to positive or vice versa?


  10. #10
    RODY
    Guest

    RE: How to make the cell or font color red if the number is negative?

    HI BOB TRY USING CONDITIONAL FORMATING GO TO TOOLS MENU / CONDITIONAL
    FORMATING / CELL VALUE IS / NOT EQUAL TO / TYPE 0 / CLICK FORMAT / CLICK THE
    BUTTON WOULD YOU LIKE TO DO

    "Bob T" wrote:

    > I'd like to make a cell change color or the cell's font change color as the
    > number in the cell changes from negative to positive or vice versa?


  11. #11
    RODY
    Guest

    RE: How to make the cell or font color red if the number is negative?

    HI BOB TRY USING CONDITIONAL FORMATING GO TO TOOLS MENU / CONDITIONAL
    FORMATING / CELL VALUE IS / NOT EQUAL TO / TYPE 0 / CLICK FORMAT / CLICK THE
    BUTTON WOULD YOU LIKE TO DO

    "Bob T" wrote:

    > I'd like to make a cell change color or the cell's font change color as the
    > number in the cell changes from negative to positive or vice versa?


  12. #12
    RODY
    Guest

    RE: How to make the cell or font color red if the number is negative?

    HI BOB TRY USING CONDITIONAL FORMATING GO TO TOOLS MENU / CONDITIONAL
    FORMATING / CELL VALUE IS / NOT EQUAL TO / TYPE 0 / CLICK FORMAT / CLICK THE
    BUTTON WOULD YOU LIKE TO DO

    "Bob T" wrote:

    > I'd like to make a cell change color or the cell's font change color as the
    > number in the cell changes from negative to positive or vice versa?


  13. #13
    RODY
    Guest

    RE: How to make the cell or font color red if the number is negative?

    HI BOB TRY USING CONDITIONAL FORMATING GO TO TOOLS MENU / CONDITIONAL
    FORMATING / CELL VALUE IS / NOT EQUAL TO / TYPE 0 / CLICK FORMAT / CLICK THE
    BUTTON WOULD YOU LIKE TO DO

    "Bob T" wrote:

    > I'd like to make a cell change color or the cell's font change color as the
    > number in the cell changes from negative to positive or vice versa?


  14. #14
    RODY
    Guest

    RE: How to make the cell or font color red if the number is negative?

    HI BOB TRY USING CONDITIONAL FORMATING GO TO TOOLS MENU / CONDITIONAL
    FORMATING / CELL VALUE IS / NOT EQUAL TO / TYPE 0 / CLICK FORMAT / CLICK THE
    BUTTON WOULD YOU LIKE TO DO

    "Bob T" wrote:

    > I'd like to make a cell change color or the cell's font change color as the
    > number in the cell changes from negative to positive or vice versa?


  15. #15
    RODY
    Guest

    RE: How to make the cell or font color red if the number is negative?

    HI BOB TRY USING CONDITIONAL FORMATING GO TO TOOLS MENU / CONDITIONAL
    FORMATING / CELL VALUE IS / NOT EQUAL TO / TYPE 0 / CLICK FORMAT / CLICK THE
    BUTTON WOULD YOU LIKE TO DO

    "Bob T" wrote:

    > I'd like to make a cell change color or the cell's font change color as the
    > number in the cell changes from negative to positive or vice versa?


  16. #16
    RODY
    Guest

    RE: How to make the cell or font color red if the number is negative?

    HI BOB TRY USING CONDITIONAL FORMATING GO TO TOOLS MENU / CONDITIONAL
    FORMATING / CELL VALUE IS / NOT EQUAL TO / TYPE 0 / CLICK FORMAT / CLICK THE
    BUTTON WOULD YOU LIKE TO DO

    "Bob T" wrote:

    > I'd like to make a cell change color or the cell's font change color as the
    > number in the cell changes from negative to positive or vice versa?


  17. #17
    RODY
    Guest

    RE: How to make the cell or font color red if the number is negative?

    HI BOB TRY USING CONDITIONAL FORMATING GO TO TOOLS MENU / CONDITIONAL
    FORMATING / CELL VALUE IS / NOT EQUAL TO / TYPE 0 / CLICK FORMAT / CLICK THE
    BUTTON WOULD YOU LIKE TO DO

    "Bob T" wrote:

    > I'd like to make a cell change color or the cell's font change color as the
    > number in the cell changes from negative to positive or vice versa?


  18. #18
    RODY
    Guest

    RE: How to make the cell or font color red if the number is negative?

    HI BOB TRY USING CONDITIONAL FORMATING GO TO TOOLS MENU / CONDITIONAL
    FORMATING / CELL VALUE IS / NOT EQUAL TO / TYPE 0 / CLICK FORMAT / CLICK THE
    BUTTON WOULD YOU LIKE TO DO

    "Bob T" wrote:

    > I'd like to make a cell change color or the cell's font change color as the
    > number in the cell changes from negative to positive or vice versa?


  19. #19
    RODY
    Guest

    RE: How to make the cell or font color red if the number is negative?

    HI BOB TRY USING CONDITIONAL FORMATING GO TO TOOLS MENU / CONDITIONAL
    FORMATING / CELL VALUE IS / NOT EQUAL TO / TYPE 0 / CLICK FORMAT / CLICK THE
    BUTTON WOULD YOU LIKE TO DO

    "Bob T" wrote:

    > I'd like to make a cell change color or the cell's font change color as the
    > number in the cell changes from negative to positive or vice versa?


  20. #20
    RODY
    Guest

    RE: How to make the cell or font color red if the number is negative?

    HI BOB TRY USING CONDITIONAL FORMATING GO TO TOOLS MENU / CONDITIONAL
    FORMATING / CELL VALUE IS / NOT EQUAL TO / TYPE 0 / CLICK FORMAT / CLICK THE
    BUTTON WOULD YOU LIKE TO DO

    "Bob T" wrote:

    > I'd like to make a cell change color or the cell's font change color as the
    > number in the cell changes from negative to positive or vice versa?


  21. #21
    RODY
    Guest

    RE: How to make the cell or font color red if the number is negative?

    HI BOB TRY USING CONDITIONAL FORMATING GO TO TOOLS MENU / CONDITIONAL
    FORMATING / CELL VALUE IS / NOT EQUAL TO / TYPE 0 / CLICK FORMAT / CLICK THE
    BUTTON WOULD YOU LIKE TO DO

    "Bob T" wrote:

    > I'd like to make a cell change color or the cell's font change color as the
    > number in the cell changes from negative to positive or vice versa?


  22. #22
    RODY
    Guest

    RE: How to make the cell or font color red if the number is negative?

    HI BOB TRY USING CONDITIONAL FORMATING GO TO TOOLS MENU / CONDITIONAL
    FORMATING / CELL VALUE IS / NOT EQUAL TO / TYPE 0 / CLICK FORMAT / CLICK THE
    BUTTON WOULD YOU LIKE TO DO

    "Bob T" wrote:

    > I'd like to make a cell change color or the cell's font change color as the
    > number in the cell changes from negative to positive or vice versa?


  23. #23
    RODY
    Guest

    RE: How to make the cell or font color red if the number is negative?

    HI BOB TRY USING CONDITIONAL FORMATING GO TO TOOLS MENU / CONDITIONAL
    FORMATING / CELL VALUE IS / NOT EQUAL TO / TYPE 0 / CLICK FORMAT / CLICK THE
    BUTTON WOULD YOU LIKE TO DO

    "Bob T" wrote:

    > I'd like to make a cell change color or the cell's font change color as the
    > number in the cell changes from negative to positive or vice versa?


  24. #24
    RODY
    Guest

    RE: How to make the cell or font color red if the number is negative?

    HI BOB TRY USING CONDITIONAL FORMATING GO TO TOOLS MENU / CONDITIONAL
    FORMATING / CELL VALUE IS / NOT EQUAL TO / TYPE 0 / CLICK FORMAT / CLICK THE
    BUTTON WOULD YOU LIKE TO DO

    "Bob T" wrote:

    > I'd like to make a cell change color or the cell's font change color as the
    > number in the cell changes from negative to positive or vice versa?


  25. #25
    RODY
    Guest

    RE: How to make the cell or font color red if the number is negative?

    HI BOB TRY USING CONDITIONAL FORMATING GO TO TOOLS MENU / CONDITIONAL
    FORMATING / CELL VALUE IS / NOT EQUAL TO / TYPE 0 / CLICK FORMAT / CLICK THE
    BUTTON WOULD YOU LIKE TO DO

    "Bob T" wrote:

    > I'd like to make a cell change color or the cell's font change color as the
    > number in the cell changes from negative to positive or vice versa?


  26. #26
    RODY
    Guest

    RE: How to make the cell or font color red if the number is negative?

    HI BOB TRY USING CONDITIONAL FORMATING GO TO TOOLS MENU / CONDITIONAL
    FORMATING / CELL VALUE IS / NOT EQUAL TO / TYPE 0 / CLICK FORMAT / CLICK THE
    BUTTON WOULD YOU LIKE TO DO

    "Bob T" wrote:

    > I'd like to make a cell change color or the cell's font change color as the
    > number in the cell changes from negative to positive or vice versa?


+ 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