+ Reply to Thread
Results 1 to 8 of 8

Excel 2007 : When you change number in one cell, certain cells change colour. How to?

  1. #1
    Registered User
    Join Date
    10-15-2008
    Location
    slovenia
    Posts
    42

    When you change number in one cell, certain cells change colour. How to?

    Hello,

    I have a table in which the first line is a phase number and it goes from 1 to 4. I would like to have something, that when I change this number a certain range in that row would change colour.
    My logic is, if A1="1" then colour in range A1 to A10 is green.
    if A1="2" then colour in range A1 to A10 is yellow.
    And so on .

    How to do it?

  2. #2
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,286
    Use conditional formatting. See http://www.contextures.com/xlCondFormat01.html

  3. #3
    Registered User
    Join Date
    10-15-2008
    Location
    slovenia
    Posts
    42
    ok, I see how it's done in older version. I use 2007 and I can't do it. (don't know how to)
    I have this data as a table (CTRL T) and I want to have 4 variables for each row. For 1 = red, 2=blue, 3=green 4=yellow
    Is it possible to have that multiple criteria?

    I attached a file for easzer understanding.
    Attached Files Attached Files
    Last edited by brazool; 11-27-2008 at 09:36 AM.

  4. #4
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326
    I'll move your thread to the 2007 forum.
    Might help you faster

  5. #5
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,286
    I think the 2007 CF dialog is a masterpiece of obfuscation and and a classic example of an inappropriate user interface, but it is not too hard to work out how to apply simple CF like this from the 2003 instructions.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    10-15-2008
    Location
    slovenia
    Posts
    42
    Thank you Bob, but can you please post a procedure or something. I want to be able to do that myself.

    Thank you for your time!!

  7. #7
    Forum Guru Bob Phillips's Avatar
    Join Date
    09-03-2005
    Location
    Wessex
    MS-Off Ver
    Office 2003, 2010, 2013, 2016, 365
    Posts
    3,286
    Select B5:D10

    Tab Home> Group Styles> Conditional Formatting> Clear Rules (just in case)

    Tab Home> Group Styles> Conditional Formatting> Manage Rules

    Click New Rule

    Select the bottom option, >Use a formule to determine which cells to format

    Enter =$B5-2 in the formula box

    Click Format...>Fill and select a colour

    OK twice, then Click New Rule again and repeat the process for the other values and fill colours.

  8. #8
    Registered User
    Join Date
    10-15-2008
    Location
    slovenia
    Posts
    42
    Hey,

    Thanks a lot!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1