=COUNTA(A1)=0

Works for text, numbers and formula blanks

=ISBLANK(A1)=TRUE

Trips on formula blanks

Biff

"Martin Fishlock" wrote in message
...
try using

=ISBLANK(A1)=TRUE

instead of

=COUNTA(A1)=0

--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"FC" wrote:

Thanks T. Valko, but this formula works just for numbers, not for
letters, if
you know another one will be appreciated.

"T. Valko" wrote:

Try this:

Select the range of cells A1:G45
Goto the menu FormatConditional Formatting
Formula Is: =COUNTA(A1)=0
Click the Format button
Select the Patterns tab
Select a color of your choice
OK out

Biff

"FC" wrote in message
...
I hava a worksheet that a fill up completely but sometimes I do not
have
all
the require information and I need to go back to it. What I need is a
conditional formating to color the whole sheet but when I write
anything
including numbers or text or dates the color disapear, that way I'll
find
easy to find the part that I did not fill up ( for ex. it will be
blue).
The
worksheet is from A1 to G1 across and from A1 to A45 down. Tx