Hi,
I have three worksheets in a workbook all listing the same values, but in different sequences. I would like to highlight a cell/value on Sheet 1 and have that same value, wherever it appears, highlighted on the other cells. Essentially, these are working lists and when I switch back and forth between tabs I want to know what value I've already completed easily.
I have a VBA that will tell me the background of the cell, but within that UDF I am not able to use the CELL("address") function for the cell being looked up on the other tabs.
Any guidance is helpful.
Thank you,
M
I have three worksheets in a workbook all listing the same values, but in different sequences. I would like to highlight a cell/value on Sheet 1 and have that same value, wherever it appears, highlighted on the other cells. Essentially, these are working lists and when I switch back and forth between tabs I want to know what value I've already completed easily.
I have a VBA that will tell me the background of the cell, but within that UDF I am not able to use the CELL("address") function for the cell being looked up on the other tabs.
Any guidance is helpful.
Thank you,
M
