Highlight selected row AND return to previous format

Hi David,

Thank you for the forum question.

It is possible but the question is, if it makes sense, because you will need a lot of hard work.

When you write bring it back to old formatting, you must talk about colours. The line "Cells.Interior.Pattern = xlNone" removes all colours from all cells, but it doesn't change number formatting.

You will need to store all the colour codes and all cell references for all coloured cells the whole sheet in an Array. It is the only way Excel can "remember" the old formatting.

Then you will need to change the worksheet change event. You will have to tell Excel what you want for all the rows you do not want to highlight.

(if not intersect(target, Activecell.entirerow) then)

You will have to loop through all cells in the Array which are not in the ActiveCell.Entirerow and then call the colour codes from the Array.

I hope this makes sense and can guide you in the right direction.




Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector