Hi there,

I am a vba novice but am trying to improve!

I have a spreadsheet with many rows of data. Some of the rows are blank. I would like a macro that would identify the blank rows and fill them with colour - or is this isn't possible, highlight them in another way.

Thanks in advance!