Results 1 to 5 of 5

Colour Cells Based Upon Value of Another Using Formula

Threaded View

  1. #1
    Registered User
    Join Date
    11-14-2010
    Location
    Wales
    MS-Off Ver
    Excel 2000
    Posts
    28

    Unhappy Colour Cells Based Upon Value of Another Using Formula

    Hello

    I wanted to colour specific cells based upon the value of other cells.
    The attached spreadsheet is a gantt chart.

    I would like to achieve:

    Shade cells in row 7 on wards, based upon the corresponding selection of F7, G7, H7, I7
    As you will see I have labelled rows 3 & 5 with the same values as appear in the drop down lists of columns F-I.
    I have shaded what I want to happen in the relevant cells in pink.

    I want this to happen automatically using a formula if possible?

    Any help much appreciated
    Thanks Debbie :O)
    Attached Files Attached Files

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