+ Reply to Thread
Results 1 to 4 of 4

Highlighting cells same color simultaneously in 2 sheets

  1. #1
    Registered User
    Join Date
    08-19-2014
    Location
    Tacoma, WA
    MS-Off Ver
    2007
    Posts
    2

    Highlighting cells same color simultaneously in 2 sheets

    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

  2. #2
    Forum Contributor
    Join Date
    01-03-2012
    Location
    Sydney
    MS-Off Ver
    Excel 2016,Excel 2013
    Posts
    186

    Re: Highlighting cells same color simultaneously in 2 sheets

    Please upload a sample file so that it makes it easy to understand the issue.

    Thanks
    Don't forget to rate 1 who helped u, using "Star"

  3. #3
    Registered User
    Join Date
    08-19-2014
    Location
    Tacoma, WA
    MS-Off Ver
    2007
    Posts
    2

    Re: Highlighting cells same color simultaneously in 2 sheets

    Here is one of my files. The sheet named all has all my names. The other sheets are sorted. I'd like to highlight the name on the "all" sheet and have the corresponding name on the sorted "qb, rb, wr, etc" be highlighted at the same time and I don't have to highlight on each sheet. I'm considering making another sheet and would like to duplicate the process on the new sheets as well.

    Totally appreciate your help!!!!!!!!!!!!!!!!!!!!!!!!

  4. #4
    Registered User
    Join Date
    08-19-2014
    Location
    Tacoma, WA
    MS-Off Ver
    2007
    Posts
    2

    Re: Highlighting cells same color simultaneously in 2 sheets

    Tried to follow the upload directions. Not sure if my file uploaded.

  5. #5
    Forum Contributor
    Join Date
    01-03-2012
    Location
    Sydney
    MS-Off Ver
    Excel 2016,Excel 2013
    Posts
    186

    Re: Highlighting cells same color simultaneously in 2 sheets

    There are no files attached. Please click on "Go Advanced" and the Attachment symbol is enabled.
    Click on attachment and upload your file.
    Thanks
    Last edited by Mysore; 08-20-2014 at 12:38 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Simultaneously add sheets to multiple workbooks
    By dorkydancer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-09-2012, 11:31 AM
  2. Hiding rows in all sheets simultaneously
    By marcelonakamura in forum Excel General
    Replies: 1
    Last Post: 08-31-2011, 02:33 PM
  3. Replies: 1
    Last Post: 05-19-2010, 12:41 PM
  4. How to apply the same background to many sheets simultaneously.
    By Colin Hayes in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 09-06-2005, 07:05 AM
  5. Replies: 6
    Last Post: 08-28-2005, 05:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1