1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Excel: value changes cell color

Discussion in 'Business Applications' started by Couriant, Sep 25, 2003.

Thread Status:
Not open for further replies.
Advertisement
  1. Couriant

    Couriant Trusted Advisor Thread Starter

    Joined:
    Mar 26, 2002
    Messages:
    32,243
    First Name:
    James
    Is there a formula to make a cell change color when that cell has a specific numeric value? IE:

    I have a small table. The total value column (say D5 - D10) is the cells I want to be color coded. D5 has the value 5. D6 has 6, D7 - 7, D8 - 8, D9 - 9, D10 - 10. Any cell that has a value of 5 and under is colored red, 6 - 8 is yellow and 9 and over is green so therefore D5 should be red, D6 to D8 is yellow and D9 - D10 is green.

    Attached is an example.
     

    Attached Files:

  2. kiwiguy

    kiwiguy

    Joined:
    Aug 17, 2003
    Messages:
    17,584
    Under Format - Conditional Format

    You should be able to accomplish what you need. It has 3 conditions to test for to apply your choice of cell format.
     
  3. tCoop61

    tCoop61

    Joined:
    Aug 5, 2003
    Messages:
    47
    You can also squeeze in a 4th color by making the base color of the cells a certain default. So, make them all red, then set the first condition as >6 and <8 = yellow, etc.
     
  4. Couriant

    Couriant Trusted Advisor Thread Starter

    Joined:
    Mar 26, 2002
    Messages:
    32,243
    First Name:
    James
    A long overdue thank you to both of you :) it's the second time that I had to do this and i forgot it, so I came back to look for it :D

    Again thank you! :D
     
As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/167265

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice