Copy color from conditional formatting result

Hi All,

i would like to copy color from conditional format table , but i don't know how
please advise ... encloses my example

i want to copy the color only from table 2 to table 1
also i added expected result inside..

thanks
did13n

Have a look at the CF I put on this.

What are the criteria that would apply here?

FDibbins

actually all i want is to coloring the table 1 using indicator in ABC/COV Column (B),
so table 1 will shown SKU per size column in one line and each size will get the color with criteria as below
if ABC COEV = A1/B1/C1 then color will be dark green
if A2/B2/C2, will be light green
A3/B3/C3/, will be yellow
A4/B4/C4, will be red

I think the CF I applied will do that

actually all i want is to coloring the table 1 using indicator in ABC/COV Column (B),

Without using VBA (or doing it manually), you cannot use a formula to copy color. If the color was applied using Conditional Formatting, then you can probably use the same rules - thats why I asked my question

Crooza, i was wrong before to copy your CF .. now seems ok. thanks for help
even i am not clear enough to understand your CF ...think i should learn more about CF logic

Originally Posted by Did13n

Crooza, i was wrong before to copy your CF .. now seems ok. thanks for help
even i am not clear enough to understand your CF ...think i should learn more about CF logic

It uses a formula to determine if the numbers 1,2,3 or 4 appear in your table two then it applies your colour scheme to the corresponding cells in table 1. CF is one thing I find hard to explain. You need to play with it. The trick is not so much getting the formula right but then applying it to the right cells. Once you realise you can apply CF to cells that aren't the same cells as the formula applies to it opens up a whole new realm!