I have multiple spreadsheets in same file with common info (i.e. names). When I highlight a name in my first sheet I want all sheets with the same name to highlight the same color. I don't need different colors. I just want all identical values (names) to highlight all at once when I highlight the first sheet. For example: on my fantasy football sheet with top 200, when I highlight a player, I also want him highlighted on the specific position sheet as well.
Is this a macro function? Is this a conditional formatting issue? Is it a function?
I've never written a macro but I understand the basics of programming.
Thanks for your help!!!
zapa98498
Bookmarks