Macro for Highlighting Blank Rows

[Em1234]

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!

[Norie]

Why not use Format>Conditional Formatting...?

[Zack Barresse]

Hi there, welcome to the board!

Can you define a little more what you are trying to accomplish? This might be as easy as Norie states - to use CF. We would still need more definition on what should be highlighted and why though. Is it blank cells in a column of choice? Completely blank rows? Do you have an example you could post?