Copy a conditional format colour to another cell

**dylanesque** · 11-17-2010, 09:58 AM

Hi
I have conditional formatting query which is driving me mad!

I have created a simple spreadsheet which for ease of explanation has just 3 rows + a header and 5 columns. Column A contains letters a to c and columns c d and e contain numerical values each with a unique conditional format colour scheme. Column b extracts values from column c,d or e dependant on the letter in column a with a simple if formula.
What I would like to do in column b is also copy the colour of the data cell being extracted from column c,d or e. Remembering that each column has its own unique conditional formatting rules.

Is this possible and if so how?

Many thanks in advance for ant assistance with this problem.
Adrian

I have attached a copy of this simple sheet to aid with the explanation.

**NBVC** · 11-17-2010, 10:19 AM

You can just copy the background colours without VBA.

But if you have minimal conditions as per your sample, then you can use conditional formatting, by combining each condition you have in the 3 columns, with the choice made in column A.

For example, in column B, you would use formulas to determine which cells to format..

and then apply 9 conditions as per the 9 conditions set in columns C:E.

so first condition would be something like:

=AND(A2="a",C2>=3)

next condition

=AND(A2="a",C2>=4,C2<=6)

next condition

=AND(A2="a",C2>6)

next conditons would be 3 for when A2="b" combined with the column D conditions and then 3 for when A2="c" combined with the column E conditions.

**dylanesque** · 11-17-2010, 12:06 PM

Thanks for that solution.

The example I gave was a much simplified version of the sheet I am working on which will contain 16 separate numerical columns each formatted into 5 different colours and 16 different types; this will probably make your formatting solution a little long. How would I go about simply copying the background colours of the qualifying cells?

Thanks again Adrian