Hi,
I think I need vba for this...
In one spreadsheet I have conditionally formatted cells with a formula to highlight the name of a staff member as well as their start year based on the year. For example:
2013 = yellow, 2014 = grey, 2015 = green. This works like a charm with the ISNUMBER(MATCH......) formula.
I subsequently have an org chart in another worksheet and want to link the name to the cell in the other worksheet AND maintain the color from the conditional formatting. I think this is possible with a vba code but I can't find one out there.
Please see the attachment for an example.
Thank you!
Bookmarks