Hi Guys,

Just a quick one, is there a simple IF formula for the following...

A B C D
E
1 ZZ II BB
2 AA
3
4 PP
OO

What I require is a formula that highlights a blank row, so row 3 would be
the correct answer here.

Again you help/suggestions are much appreciated!

Regards,
James.