Workbook 1
Sheet A
Sheet B
Sheet C
Is it possible to click on a hyperlink in Cell A1 of Sheet A and link to cells C1, C6, and C13 of Sheet C and change the color of those 3 cells, but click on a hyperlink in Cell A2 of Sheet A and link to cells C2, C10, and C19 and change the color of those 3 cells? Also, after clicking back to a different sheet or cell, the previously highlighted cells are now switched back to no fill? I am currently using Excel 2013.
Bookmarks