Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Posts
    304
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Color condition on values in cells? (Excel 2000 SP-3)

    I am working with an inventory spreadsheet. We have certain items that, if we get down to only 2 of them, we need to be signaled to order more. I would like to figure out some way to color code them so that if the value is equal to or less than 2, the font color of the value turns red instead of black. I can't remember if there is a way to do that automatically in Excel, or if I will have to create a macro of some sort. Any suggestions? Thanks in advance.

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

    Re: Color condition on values in cells? (Excel 2000 SP-3)

    You can use conditional formatting for this.
    Select the cell or cells you want to modify.
    Select Format | Conditional Formatting...
    Leave the first dropdown box as is ("Value is"), and in the second dropdown box, select "less than or equal to". Type 2 in the box to the right.
    Then click the Format... button, and select the red font color, and other options if you wish. Click OK to return to the Conditional Formatting dialog.
    Click OK to close this dialog. That's it.

Posting Permissions

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