cell color

[Sebseb]

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

 

[MARK858]

Very few colors have an official name plus you cannot get them via formula. You would need VBA.

 

[Sebseb]

Tnx Mari... can you help me with this code... l‘m trying almost for a mounth but all vba which I try doesn’t work... or maybe somebody else can help me with this code...

 

[Sebseb]

Mark.. not Mari