Hi,

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

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

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

Can anybody help me with this?

Thanks in advance, Titus

--
titushank
-----------------------------------------------------------------------
titushanke's Profile: http://www.excelforum.com/member.php...fo&userid=1999
View this thread: http://www.excelforum.com/showthread.php?threadid=46919