Formatting cell in same row as active cell, then reset format on row selection change

[jellyjen17]

Hello,

I have the following code, which will format the cell in column D of the same row of the active cell, changing the font to bold and color to red. This works, except when another cell is selected in a differet row, I need to reset the format of the column D cell that was just changed. How do I reset the format of that cell (bold=false, color=black)?

Any help would be much appreciated!


Code:

Please Login or Register  to view this content.

[TMS]

Don't select the cell

Please Login or Register  to view this content.

Regards, TMS

[jellyjen17]

Hello,

I tried this, but to no avail. Same problem is happening. After a cell in a different row is selected, the column D cell of the previously selected cell remains bold font and color red.

[OnErrorGoto0]

I think it would be easier to do with conditional formatting, but for this method you need to store the previous cell

Please Login or Register  to view this content.

[jellyjen17]

Hi TMS,

This worked like a charm, thank you much! I did think about conditional formatting, but can you conditional format a cell based strictly on the selection or activation of another cell? I wasn't sure how to do that either or if it was even possible and just figured a vba code solution would be easier to find.

thanks again!

[TMS]

Much as I'd like to take the credit ... and I was planning on coming back with something similar ... it was actually OnErrorGot0 that answered the question for you.


Regards, TMS

[jellyjen17]

Oops, I didn't even see that! Sorry, & thank you much OnErrorGot0 for your help! Thank you both for such timely responses as well!

[TMS]

You're welcome.

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[jellyjen17]

Will do, thank you!