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

    Conditional Formatting (2000)

    I know there must be an easy answer to this, but it is too early in the morning. I have the following formula in cell C1: "=If(isnumber(A1),A1*B1,if(istext(A1),A1,""))" . In addition, I have conditionally formatted C1 such that if the results are less than or equal to zero, the fromat is bold red, and if greater than zero, bold green. My question is, how can I turn off the conditional formatting when the result of the formula is text, such that it would be formatted as regular text (i. e., black, not bold)?
    Thanks,
    Jeff

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

    Re: Conditional Formatting (2000)

    You must add a condition, but it must the first one.
    In the first box, you must select Formula Is instead of the default Cell Value Is; in the second box, enter the formula =ISTEXT(C1). Click the Format.... button and select Black as color and any other formatting options you want.

    Note: I still use Excel 97; it provides no way to re-order conditions AFAIK, so I would have to delete the existing conditions, enter the one for =ISTEXT(C1) and then re-create the ones for positive and negative numbers. I don't know if this is easier in Excel 2000.

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

    Re: Conditional Formatting (2000)

    Thanks, Hans. Works fine.
    Jeff

Posting Permissions

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