I would like to use conditional formatting to test whether a cell
contains text or a formulae and higlight all cells as they are
overtyped.

I have tried using Type() but doesnt recognise difference between sam a
number keyed in and a formulae beginning =if(. . . .

Any ideas?


--
Ruthki
------------------------------------------------------------------------
Ruthki's Profile: http://www.excelforum.com/member.php...o&userid=24503
View this thread: http://www.excelforum.com/showthread...hreadid=380978