Hello everybody
I have this code that highlight activecell's row and column .. The problem is that it removes interior colors of the cells and I can not color the bakground of any cell ..
can the code be edited to keep interior colors and to enable me to color the background of any range..
Please Login or Register to view this content.
Sure, but with one caveat: this will wipe out all conditional formatting instead.
This code uses the same logic, but instead applie temporary Conditional Formatting to the row and column which has the benefit of not overwriting normal cell formatting.
Please Login or Register to view this content.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Great solution I testes it and it is really awesome .. But what about conditional formatting?
Is there a solution ??!!
I went a similar route.
A Sheet specific macro enters the activecell address into p1
That triggers two conditional formats.
Please Login or Register to view this content.Formula:
Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
Last edited by mehmetcik; 12-26-2014 at 04:54 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Simple and perfect
Thank you very much for this great solution
Can it be done to be like the first code? I mean not to highlight all the cells of the row and all the cells of the column ..
Just highlight the left cells of the active cell and the top cells of the active cells
I think so,
Just and an and to the conditional formats
Formula:Please Login or Register to view this content.
Excellent solution
Thank you very much you are wonderful
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks