Vba to copy cell interior color

Hi..



I'm new here and I tried to look if I'll find solution for my problem but I was unsuccessful. I create document in excel 2013 and in first worksheet I have table with few columns.

In first column is name of material in second I want to show color and name of color which I choose/add in second worksheet...and all the time when I add new worksheets with new name of material, they show all in table... my problem is... in my table I can not do that they show me color and name of color in second cell of column, which I add or choose in another worksheet and cells that show this color and name of color have to be linked on name of material which you find in first column... and cell with this color and name has to follow up and down name of material, because I all the time add or delete new worksheets with different name of material...



in another columns in table I used this formula



=IF(ISERROR(VLOOKUP($C$1;INDIRECT("'"&ZALOGA!$A2&"'!$A$11:$B$11");2;0));" ";(VLOOKUP($C$1;INDIRECT("'"&ZALOGA!$A2&"'!$A$11:$B$11");2;0)))



which work great, only I have problem with cell in second column who have to show name of color and backgroundcolor



can anybody help me

here is

Barva = Color

i need vba code for second colum wich show color and name of color in tabel ( worksheet ZALoga) which I choose/add in atherworksheet and this color have to go up or down basic on name in first colum

i wish that blue color follow cell text from first column and for this i need VBA code...

:)))

yes, i m sure 100%

sample does not have code because i have not that code

i ask you if you can halp me and create this code

btw sorry on my eng.. is not so good

if i had this code i put in sampel and ask where is problem with code, but i have not and try to finfdit

can somebody help me with this problem??

sorry but i am not czech

can we speak privately??

Quote from Carim

Code

Hello,


Unfortunately ... your explanation of what you want to achieve ... is extremely confusing ...

if look my print scr p3 you will see tabel and my wish or what i need is:

- all time when i add or remove new sheet (name of new sheet is show in colum a) in colum b color shoul be follow name from colum a