Hi,

I have a file that contains more than 2050 rows and therefore I cannot use conditional formatting (limitation).

What I am looking for is some VBA code that highlights a cell (pattern color) if there is NO FORMULA in this cell.

This could be valid for a whole sheet, no need to specify a range (but it would be cool to know both ways).

Can anybody help me with this?

Thanks in advance, Titus.