Hi all,
I'm looking for highliting the active cell in a sheet.
There are so many posts and vba codes I found on the net, and tried them all but I can't get passed conditional formatting telling me it's got a problem with the formula.
I copy paste all the formulas I could find but none of them seems to work.
Is there and other way like straight with vba code without conditional formatting ?
Thx all,
OD
You cannot highlight the active cell with regular conditional formatting, so it will have to be VBA.
Please provide a sample workbook that your helper can use to set up a script for you.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
This one gives me an error "wrong formula" ? =AND(COLUMN()=CELL("COL"),ROW()=CELL("ROW"))
This one does nothing actually
Please Login or Register to view this content.
Last edited by AliGW; 03-24-2024 at 08:29 AM. Reason: Code tags added - please review the forum guidelines.
For your locale, you'd need a semi-colon, not a comma:
=AND(COLUMN()=CELL("COL");ROW()=CELL("ROW"))
There's a spelling error in the code:
Should be 'address'.Please Login or Register to view this content.
Correct, the comma I got from an older code, so I changed it in to a semi-colon and the formula is exepted now.
For the vba code I copy paste your quote ...
Still nothing happens, I mean there are no errors in both formatting or vba but, still nothing happens. I can click any cell i want but it stay white.
I still miss something, or forgot, or just don't know (yet) :-)
I highlighted the spelling error in the code - I did not correct it. It should be this:
Please Login or Register to view this content.
Ohhh I see, sorry lol, It's the age and the eyes, plus English is not my native language, some words I go over it too fast, specially when ADDRESS is spelled ADRES in Dutch ;-)
But any how, still not working.
Pls try this code
Please Login or Register to view this content.
Last edited by wk9128; 03-25-2024 at 07:17 AM.
Code for a sheetPlease Login or Register to view this content.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
That's one big step forward for sure.
Although second question connected with it, on my worksheet I have several ranges in differend colors set up and this code will turn the whole sheet in white. Is it possible to set only the cell I'm working with in a coulour without changing the whole sheet?
I have changed some numbers with in the first line so the sheet goes completely black on nr 1, 2 is grey, 3 is red, 4 is green. But then it will araze the whole sheet.
Are we still missing something here ?
Is this a stand alone code or has it has to go with some others, like color, etc, bacaus on its own it has no effect what so ever.
This code should use Worksheet_SelectionChange instead of Worksheet_ChangeOriginally Posted by JohnTopley
Please Login or Register to view this content.
This code will put the address of the active cell into cell A1 anytime the user changes the selection. To format the active cell, this code must be used together with a conditional formatting rule:Please Login or Register to view this content.
Formula:
Please Login or Register to view this content.
Applies to:
Formula:Please Login or Register to view this content.
(entire sheet)
This could be done all in VBA without adding a conditional formatting rule, but the code would have to make a record of the original formatting of the cell first so it can be restored when the selection changes. Or the code would have to continually create and destroy conditional formatting rules on the fly. These options are more complicated than just adding a conditional formatting rule.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
This is great, it's working lik a charm now.
Thx for your input and time :-)
Administrative Note:
We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not told us about this. You are required to do so. Cross-posts are allowed but you must provide a link to your posts on other sites.
Please see Forum Rule #7 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important: https://excelguru.ca/a-message-to-forum-cross-posters/
(Note: this requirement is not optional. I shall do it for you once only: https://www.helpmij.nl/forum/threads...e-cell.971463/)
Yes, I posted some thaughts on a Dutch help page, if that might help You, because sometimes there are issues with Dutch and English connotations in programming, it help when programs use both languages. For example, the vba code mostely is English, but conditional formatting is Dutch. Is there a special spot where I can place it or is just telling enough, I didn't know it was that important, there for my excuses.
When you post the same question to another site, we require that you provide a link here so people can see if it's already been answered someplace else. A link in your post is all that's needed.
We don't have many rules, and they are all important.
Ok thx, will do!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks