Colour Cells based on the value of another cell

[Macca_GB]

Hi, in the attached sheet I am trying to colour cells based on the value of other cells eg, if cell
B2 is "1", conditional formatting turns it green. I then need Cell H6 also to turn Green but retain the original cell value, ie "2". I want to repeat this for all 4 Switches (RH1SAB00 etc).

Thanks in advance

[zbor]

In H6 use this for conditional formating: =INDEX($B$2:$B$49,MATCH(H6,$A$2:$A$49,0))=1

For other switches use other index range:

$C$2:$C$49
$D$2:$D$49
$E$2:$E$49