Results 1 to 4 of 4

Copying Cell Background with Formula

Threaded View

  1. #1
    Registered User
    Join Date
    06-29-2010
    Location
    Minneapolis, MN
    MS-Off Ver
    Excel 2016
    Posts
    75

    Copying Cell Background with Formula

    NBVC will cringe at this, but I have another question.

    I have a column which is divided into 5 different color groups, their sizes depending on user input.

    I now need 3 adjacent columns to have the same cell color backgrounds, and to be updated alongside the original column when the user updates the group sizes.

    This seems fairly easy, but I'm not entirely sure where to begin. I don't think conditional formatting would be very helpful, perhaps this is more of a VBA question?

    Cheers,

    Simon

    EDIT: I have attached a sample of the final product, no code involved.
    Attached Files Attached Files
    Last edited by Dynamo418; 07-07-2010 at 07:47 PM.

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