I have different people in an org chart on excel that have hyperlinks to a range of cells on a different sheet showing data. is there a way to make that range of cells highlight when it takes me there from clicking on the hyperlink, but not highlight if i just go to that sheet directly?

Thanks

Ryan