Hello! I am a VBA newbie and this is my first forum post so go easy on me!
I need some code to highlight the row between columns B and I light green and change font colour to dark green ("good" style) if the cell in column I contains a tick. I already have the code to do this but I need it to revert to the old formatting if the tick is removed. Ticks are added or removed with a double click (which I have already coded successfully) so maybe the formatting code could be merged into this?
Conditional formatting code:
Insert/Remove tick code:
I know this can be done super easy with conditional formatting, and had it set up to do so! However, I have some code that deletes rows depending on certain criteria which messes up the conditional formatting ranges and I can't think of a way to fix that.
I've attached my work book so you can see what I'm talking about.
Any help or resources would be appreciated! Thank you!
Bookmarks