Hello.
I have got a workbook with multiple sheets. Workbook is in attached files.
When I click "NEW NAME" I set name and color of new person. In other sheets are list validations, where I can choose one of this names.
I want to copy color of interior from "LIST" to others, when certain name is selected in list validation.
I would like to do this in VBA code, because shhets can be more.
Any help will be appriciated.
Sorry for my English 
Re: Setting colors of cell interior in other sheets
Hi,
In the module ThisWorkbook .... Ten_skoroszyt ... (my Polish is very weak ...) :wink:
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
Dim x As Long
For Each Sh In ThisWorkbook.Sheets
If Sh.name <> "LIST" Then
If Target.Column <> 1 Then
x = Application.Match(Target, Sheets("LIST").Range("A1:A100"), 0)
Target.Interior.Color = Sheets("LIST").Cells(x, 1).Interior.Color
End If
End If
Next Sh
End SubHope this will help
:smile:
Re: Setting colors of cell interior in other sheets
Polish is hard to learn
Thank you, both* replies work great!
* My reply deleted. Practically the same as Carims... and he (assumption, apologies if wrong) got there first.
C
Re: Setting colors of cell interior in other sheets
Hi again.
I would like to extend my workbook.
In this version I have got new sheet named "SUMMARY" and data in first two columns. Background color of the cell is changing when I set cursor in formula bar and press enter. Why color is not changing automatically when I choose new person in let's say "1DAY" sheet? How to fix it?
Any tips? 
Re: Setting colors of cell interior in other sheets
MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question
*
Don’t have an account yet? Register yourself now and be a part of our community!