Hello
I want to Highlight Column When Cell Selected Without Removing the Sheets Other Background Colours in the sheet.
The code is am using is:
But it removed all my other background row colours, does anyone know how to stop that from happening?
Please Login or Register to view this content.
Maybe remove the red?
Please Login or Register to view this content.
Just tried it John but unfortunately does not work. The green highlighted column will not disappear when a new column is selected if that line is removed.
Check your conditional formatting. If you colors are obtained through conditional formatting then you can't manipulate the colors the way you are attempting, and that may be the cause of the problem.
There is no conditional formatting on my excel sheet
Try this out:
Please Login or Register to view this content.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
That works much better! But is there a way to have the original colour replaced once a different column is selected?
? It should do that the way it is... I made a sheet yellow, and each time I selected another, the green went back to yellow, and the new one green.
You did copy the 2 lines above the sub also right? those are private variables to the sheet, that store the previous column and colour
I did copy the whole thing, that is strange my sheet is definitely not returning back to the original color (yellow in your case)
I even tried making some yellow, others red, others white, and some no colour... the active column goes to green, and the others revert to original colour... can you maybe attach your workbook? No data needed for this... just the book with at least the sheet that has this code.
Here is the sheet:
Liquid Fertilizer Formulation Calculations-v3.xlsm
mackenzie,
Now I see the problem... you have different colours in different rows... i had not realized that, so my code based the "old" colour stored in a variable on the cell that gets clicked. I'll have to give this some thought.... but I am not sure what you want is possible without storing a LOT of temporary data.
Do you know how many rows will need to have this applied? What I mean is, is there a limited number of rows that will need to be reset to the "old" colour? Or will the number of rows grow over time?
Last edited by Arkadi; 05-15-2015 at 08:49 AM.
The number of rows should not increase, just the number of columns.
Ok, give this one a shot... I have also provided a workbook_beforesave macro, so that on saving it does not save with the column highlighted (I believe... leaving final testing to you). The only thing is.... to avoid saving with highlight, the variables that store the old column and colour need to be public variables, and you are not allowed to have public variables in events. So in a normal module, at the top, put:
Then in the sheet's code:Please Login or Register to view this content.
And then in "ThisWorkbook" :Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks