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?
Bookmarks