+ Reply to Thread
Results 1 to 3 of 3

Change colors of all values when one cell has the focus

  1. #1
    Registered User
    Join Date
    01-25-2016
    Location
    Ottawa, Canada
    MS-Off Ver
    2010
    Posts
    7

    Change colors of all values when one cell has the focus

    Hi, Hope you can help.

    I have a worksheet with thousands of values (in B:B). Not all cell values are different. Some cells are unique, but some cells have identical values.

    I have a list of unique values (in F:F). When I select a cell in F:F, I'd like to change all other identical values in the worksheet to color(7).

    I have this I found here, but it only highlights the current selection.

    Please Login or Register  to view this content.
    Many Thanks
    Last edited by Proventus; 01-25-2016 at 09:44 PM.

  2. #2
    Registered User
    Join Date
    01-25-2016
    Location
    Ottawa, Canada
    MS-Off Ver
    2010
    Posts
    7

    Re: Change colors of all values when one cell has the focus

    Found a solution and posting in case someone needs it.

    Part1
    Please Login or Register  to view this content.
    Part 2
    Please Login or Register  to view this content.
    Last edited by Proventus; 01-25-2016 at 09:58 PM.

  3. #3
    Forum Guru mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,203

    Re: Change colors of all values when one cell has the focus

    There is another way to do this.

    First create a named value
    Name: MyValue RefersTo: =4

    Then Select B1, apply Conditional Formatting with the formula =(B1&""=myValue&"")

    Then put this code in the sheet's code module.

    Please Login or Register  to view this content.
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

+ 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. Replies: 3
    Last Post: 10-21-2015, 03:51 PM
  2. Worksheet On Change Calls Sub to change Cell colors
    By sportsguy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2014, 12:20 PM
  3. [SOLVED] Change Focus on Cell Select
    By thesonofdarwin in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 05-07-2012, 10:14 PM
  4. [SOLVED] How to change or populate cell values based on cell colors
    By MrMacroMan in forum Excel General
    Replies: 8
    Last Post: 05-02-2012, 11:34 AM
  5. Change the cell focus based on month and year
    By gruf1968 in forum Excel General
    Replies: 4
    Last Post: 01-24-2010, 12:30 PM
  6. Cursor Keys does not change cell focus
    By Skypilot in forum Excel General
    Replies: 4
    Last Post: 02-24-2005, 06:34 PM
  7. Replies: 1
    Last Post: 02-05-2005, 02:06 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