Results 1 to 3 of 3

Auto color coding a cell with a formula

This is a discussion on Auto color coding a cell with a formula within the Excel Questions forums, part of the Question Forums category; I am trying to find out how you would color code a cell. I'd like to have it set so ...

  1. #1
    New Member
    Join Date
    May 2002
    Posts
    34

    Default

    I am trying to find out how you would color code a cell. I'd like to have it set so if the results of the formula in that cell are greater than 97, the cell is colored green. If the results are less than 97 it would be red. Is there an Excel formnula that would allow for this?

    Thanks!

  2. #2
    IML
    IML is offline
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Denver, CO
    Posts
    1,744

    Default

    On 2002-07-05 10:45, bdanner wrote:
    I am trying to find out how you would color code a cell. I'd like to have it set so if the results of the formula in that cell are greater than 97, the cell is colored green. If the results are less than 97 it would be red. Is there an Excel formnula that would allow for this?

    Thanks!
    You can use conditional formatting for this.
    Highlight the cells you want this to happen for.
    Choose conditional formatting from the format menu.
    For condition one, select greater than from the drop down box, and type in 97.
    Click on the forat box and choose a green color.
    Click on the add button, and repeat the process for your less than 97 criteria.

    Good luck

  3. #3
    Board Regular
    Join Date
    Jul 2002
    Posts
    55

    Default

    You can do this through Conditional Formation:

    Fromt the Format Menu, go to Conditional Formation
    on Condition1: from the drop down menu select Formula Is: and type =A1>=97
    (note: A1 is the cell that you are evaluating)
    click on Format button, select the Pattern tab and choose the color green
    Follow this by adding a condition by clicking on Add>>
    repeat with formula =A1<97 and choose color red on the pattern tab

    -Sylvia

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com