Unsure Where to post my question – so patience please if this is not the correct place.
Old programmer – New to excel – I need to take a spreadsheet and link other cells to that cell (manually). When a user clicks on a cell, I need the other cells “linked” to that cell to be highlighted. I’ve read up some on Vlookup, If, Hyperlink, etc… and can certainly highlight using conditional formatting, but I need to be sent in the direction of the quickest and easiest way to finish this.
The purpose of the spreadsheet, or multiple spreadsheets, is to find affected values (for example Web and App Servers) when a cell with a value (for example a particular Firewall Server) is selected.
Hopefully this made some sense,
Thanks,
New and Confused
