Results 1 to 7 of 7
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Multiple Conditions-Conditional Formatting (2000)

    I know there is an easy answer that I have seen before, but I can't seem to locate it: I want to put 3 different formats depending on a cell's values-if the cell value is greater than zero, the format would be bold green; if less than zero, the format would be bold red. I have no problem with those two. However, I want the third condition to be that when the cell value is actually text ("N/A", for example, without the quotation marks), I want the format to be bold black. Any help?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multiple Conditions-Conditional Formatting (2000)

    Are you sure you mean text, and not an error value #N/A ? Excel distinguishes between text and built-in error values.

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Multiple Conditions-Conditional Formatting (2000)

    Text.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multiple Conditions-Conditional Formatting (2000)

    You might set the standard formatting of the cell to bold black.
    If you need to set it in conditional formatting, select Formula Is in the condition dropdown box, and enter =ISTEXT(A1) in the box next to it, where A1 is the cell. Then click the Format box to set bold black formatting.

  5. #5
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Multiple Conditions-Conditional Formatting (2000)

    I tried it but it didn't seem to work until I put the "text" condition as the first condition.
    Thanks.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multiple Conditions-Conditional Formatting (2000)

    Yes, the order of the conditions in condtional formatting is important. If A1 contains a text value, the condition A1 > 0 is TRUE, since Excel sorts text after numbers (look up sort in the help). So if you want to test for text values, you must do it first.

  7. #7
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Youngstown, Ohio, USA
    Posts
    705
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Multiple Conditions-Conditional Formatting (2000)

    Attached is one way you could set it up. The first test uses a formula-based evaluation to check for either a text value or an error, where the other two just check the cell value.

Posting Permissions

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