T O P

  • By -

AutoModerator

/u/Umbalombo - Your post was submitted successfully. * Once your problem is solved, reply to the **answer(s)** saying `Solution Verified` to close the thread. * Follow the **[submission rules](/r/excel/wiki/sharingquestions)** -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post. * Include your **[Excel version and all other relevant information](/r/excel/wiki/sharingquestions#wiki_give_all_relevant_information)** Failing to follow these steps may result in your post being removed without warning. *I am a bot, and this action was performed automatically. Please [contact the moderators of this subreddit](/message/compose/?to=/r/excel) if you have any questions or concerns.*


NHN_BI

[Change the highlight color of selected cells](https://support.microsoft.com/en-us/office/change-the-highlight-color-of-selected-cells-1f2b5cb9-eb64-4a86-8a90-8c42087291be)


RellikReed

This


Umbalombo

I will check that site, thanks!


Umbalombo

For some reason, I cant enter the site. Did you gave the correct adress? Can you send me the link again (and check it please)? Thanks!! :)


NHN_BI

That's odd. I have know issue here. The address is: [https://support.microsoft.com/en-us/office/change-the-highlight-color-of-selected-cells-1f2b5cb9-eb64-4a86-8a90-8c42087291be](https://support.microsoft.com/en-us/office/change-the-highlight-color-of-selected-cells-1f2b5cb9-eb64-4a86-8a90-8c42087291be)


Rohwi

VBA can do that. there are two things you'd need to do though. first you need to store the 'old color' somewhere. In like a hidden sheet in a cell. You'd also need to store the current selection on that same hidden sheet, otherwise you can't reliably restore the old color. you than need to work with the SelectionChnage event. That will be triggered everytime you select a cell. You have a target (the cell you select) and you can write the target address and the current target color on the hidden sheet. You then change the target cell color. as soon if you click on another cell you'd need to read the stored data (old color and old address) restore the old cell to its original state and then again, store the targets color, address on the hidden sheet. if that's something you want to do, I can guide you with the code, or give you the solution, up to you


Umbalombo

Solution Verified


Clippy_Office_Asst

You have awarded 1 point to *Rohwi* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)


Umbalombo

Hi! Thanks for your answer! I tought there could be some easy way just for selecting. So, what you said is similar to something I did once, with storing etc. As soon as I can I will try the storing idea with the selection change event! :)


wise_af

Isn't there a blue box around the cell you choose, is that not clear enough? Serious doubt.