I am using a name manager to get the color for the cell of the table on the left (yellow/orange).
Is there a way I can get the color code to show on the right table?
That way, I can modify the left table as I please and the right table will pick it up (refresh)
The formula I have in the name manager is =GET.CELL(63,INDIRECT("RC",0)) it is named "qq"
I tried in cel "P6" =qq(E6), but it didn't work
Is there a way I can get the color code to show on the right table?
That way, I can modify the left table as I please and the right table will pick it up (refresh)
The formula I have in the name manager is =GET.CELL(63,INDIRECT("RC",0)) it is named "qq"
I tried in cel "P6" =qq(E6), but it didn't work
HOS.xlsm | |||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | |||
4 | BODY PERSON - Streetsville | BODY PERSON - Streetsville | |||||||||||||||||||||
5 | BADGE # | NAME | 12-Apr | 19-Apr | 26-Apr | 03-May | 10-May | 17-May | 24-May | BADGE # | NAME | 12-Apr | 19-Apr | 26-Apr | 03-May | 10-May | 17-May | 24-May | |||||
6 | 1 | 5143 | 1 | 5143 | |||||||||||||||||||
7 | 2 | 5235 | 2 | 5235 | |||||||||||||||||||
8 | 3 | 5134 | 3 | 5134 | |||||||||||||||||||
Sheet1 |