PDA

View Full Version : Macro for Highlighting Blank Rows



Em1234
11-02-2006, 09:05 AM
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
11-02-2006, 09:36 AM
Why not use Format>Conditional Formatting...?

Zack Barresse
11-02-2006, 09:39 AM
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?