+ Reply to Thread
Results 1 to 2 of 2

Using values from one group of cells to format a separate group of cells

  1. #1
    Registered User
    Join Date
    02-17-2011
    Location
    ontario
    MS-Off Ver
    Excel 2003
    Posts
    1

    Using values from one group of cells to format a separate group of cells

    I have a spreadsheet where in one column I have several groups of names that need to be highlighted in certain colors dependant on the values coming up in a different column.

    In column D rows 6 through 36 and rows 40 through 56 there are names.

    In column G (equivalent rows to D) there are values ranging from zero to one hundred percent.

    What I need is for the values in column G to deterkine the coor of the cells in column D.

    100 = red
    75 to 100 (75 included 100 excluded) = orange
    50 to 75 (50 included 75 excluded) = yellow
    25 to 50 (25 included 50 excluded) = pale yellow
    0 to 25 (0 and 25 excluded) = green
    0 = pale grey

    If there is any more info needed to make this clearer just ask, any insight would be greatly appreciated!

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Using values from one group of cells to format a separate group of cells

    If using XL2003 as implied you will need to use VBA for this.

    A sample file would help as this will help people identify by what means the values in G are populated (formulae, constants)

    The work flow is important as this will determine the VBA Event you use to control the formatting process.

    If possible include a colour key in your sample file so we can determine the colour indexes you wish to use.

+ 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