Cells will not highlight in my defined range

[jayinthe813]

Hello, I am attempting to use the following code to highlight an entire row if a cell in my range is blank. I am not sure why, but it wont highlight. Im assuming its because im not defining a blank cell correctly. Any ideas?

Please Login or Register  to view this content.

Thanks!

[protonLeah]

Please Login or Register  to view this content.

Also, you have: Then cell... vs. cell2.

[jayinthe813]

Wow, worked great, +rep! May I ask why the logic in the coding I had failed?

[protonLeah]

You coded:
For Each cell2 in ..., cell2 is the variable which is holding all the data and application info for the cells in the range being tested. However, your If..Then statement uses "cell". This is a different variable from cell2 and is totally empty since you did not use it before; it has to application information or user data information.
Notice that I put "OPTION EXPLICIT" at the top of my macro. That line forces you to define all of your variables, so when you try to run your macro you'll get an error highlighting "cell" in the IF..Then line because "cell" is undefined.

[jayinthe813]

Right, I see where I made the mistake. Thanks so much for your help!