+ Reply to Thread
Results 1 to 1 of 1

How to highlight active row and column except for the cells that are already highlighted?

  1. #1
    Registered User
    Join Date
    04-04-2012
    Location
    IN, USA
    MS-Off Ver
    Excel 2010
    Posts
    1

    Question How to highlight active row and column except for the cells that are already highlighted?

    I found the code below on http://www.xcelfiles.com/Excel02.html. It is so close to what I need to do. Dear Juan Pablo, if you read this post, I would love your help in making a little adjustment to the code you have below.

    It highlights active row and column, but it overwrites the already colored cells. I need it to highlight active row and column while it keeps the already highlighted cells in their original color. So, say I have some cells in yellow. When the code highlights the active row and column in (say) purple, I would like to be able to see the the whole row and column in purple while the yellow cells remain in yellow.

    So can anyone tell me how to make the code below keep the original cell color of the already highlighted cells while it highlights the rest of the cells in the active row and column? Pleasee help?

    Thank you!
    Please Login or Register  to view this content.
    Last edited by Leith Ross; 04-04-2012 at 03:17 PM. Reason: Added Code Tags

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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