Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Jul 2005
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Changing Cell Color with Formula (2000)

    Hi. Is there a way to use a formula (probably an if-then statement) so that if a condition is not met, the cell color changes? I'm looking for a way to "flag" a cell. Specifically, if cell A1 references cell B1, I want cell A1 to change color, have bold text, etc (distinguish itself) if cell B1=0.

    Thanks so much.

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

    Re: Changing Cell Color with Formula (2000)

    Welcome to Woody's Lounge!

    Formulas cannot change the background color of a cell (I assume that's what you want to change). You can probably use conditional formatting:
    - Select cell A1.
    - Select Format | Conditional Formatting...
    - Select "Formula Is" from the first dropdown list in the dialog.
    - Enter =(B1=0) in the box next to it.
    - Click Format...
    - Activate the Patterns tab.
    - Set the background color you want.
    - Click OK to close the Format Cells dialog.
    - Click OK to close the Conditional Formatting dialog.

Posting Permissions

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