Copying Cell Background with Formula

**Dynamo418** · 06-30-2010, 05:30 PM

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.

**royUK** · 07-01-2010, 01:20 AM

Do you mean that you want the new cells to match the changes in the other colums? I can't see why Conditional Formatting wouldn't work

**Dynamo418** · 07-01-2010, 09:01 AM

Yes, that's what I want; the cell colors to change alongside the original. How would I do this with cond. formatting? Not very familiar with it.. thanks!

Edit: The other columns will have different numbers than the original, all that should be the same are the backgrounds of the cells, which will change based on user input.

**NBVC** · 07-04-2010, 10:22 PM

If you use the exact same formulas in the all the 4 columns.. ensuring that the column references are absolute (i.e. make sure $ sign before column letter) then the colours should apply the same to all 4 columsn.

So, for example.

Condition 1 for all 4 columns (including column C) should be changed from:

=SUM($C$2:$C$45)-SUM(C2:$C$45)<$F$2

to

=SUM($C$2:$C$45)-SUM($C2:$C$45)<$F$2

and condition 2 should be changed from:

=AND(SUM($C$2:$C$45)-SUM(C2:$C$45)>$F$2,SUM($C$2:$C$45)-SUM(C2:$C$45)<=SUM($F$2:F$3))

to

=AND(SUM($C$2:$C$45)-SUM($C2:$C$45)>$F$2,SUM($C$2:$C$45)-SUM($C2:$C$45)<=SUM($F$2:F$3))

Notice the $ added.