Automatically change fill color on certain cells depending on color of specific cell

**cbouley** · 07-08-2010, 03:10 PM

Hi everyone,

I have a tedious task of highlighting and changing the fill color of certain cells. There is a specific pattern that needs to be changed everytime.

Since the color is always consistant throughout the certain cells, I would like to make 1 cell be the master cell and every other cell in my pattern copy the color fill of the master.
Therefor if I change the color of the master cell, every other cell in the pattern would automatically change itself to the same fill color.

Would there be a general solution to this with an equation or would it involve writing a macro for it.

Thanks in advance

**JBeaucaire** · 07-08-2010, 04:51 PM

Both a formula approach (conditional formatting) and a macro could do this. You will have to provide a sample workbook fully demonstrating your need to get a reasonable answer with either method.

========
EDIT: Actually, formulas can't analyze colors, so most likely only a macro will do.

**cbouley** · 07-08-2010, 05:17 PM

I figured as much, heres a sample if anyone has any workarounds for my problem.

**JBeaucaire** · 07-08-2010, 06:48 PM

This is the best I can offer...color changes in a cell don't actually trigger a ws_change event...I have no idea why, a lacking in Excel I suppose. So, this will trigger the color match when you move to another cell.

Put this macro into the SHEET MODULE for Sheet1 and it will work automatically:

Option Explicit

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Range("C9,C11,C13,C15,C17,C19,C21,E9,E11,E13,E15,E17,E19,E21") _
        .Interior.ColorIndex = Range("D6").Interior.ColorIndex
End Sub

Automatically change fill color on certain cells depending on color of specific cell

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Automatically change fill color on certain cells depending on color of specific cell

Re: Automatically change fill color on certain cells depending on color of specific c

Re: Automatically change fill color on certain cells depending on color of specific c

Re: Automatically change fill color on certain cells depending on color of specific c

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions