Please can you expain what a formula blank is if you mean =if(1=1,"","no
blank") then both yours and mine show none blank which would assume is
correct because it is some form of calculation.

Yes, if 1=1 return an empty TEXT string. Aka a formula blank. But, ISBLANK
does not recognize a formula blank as BLANK.

A1 = =""

=ISBLANK(A1) = FALSE

ISBLANK should be named ISEMPTY

COUNTBLANK, otoh, will recognize a formula blank.

=COUNTBLANK(A1) = 1

I just used COUNTA because I'm anal! COUNTA will recognize anything that's
in a cell.

Biff

"Martin Fishlock" wrote in message
...
Biff:

Sorry, I don't know what I was doing I re-tried it and your suggestion
works
fine.

Please can you expain what a formula blank is if you mean =if(1=1,"","no
blank") then both yours and mine show none blank which would assume is
correct because it is some form of calculation.

Anyway can the OP please explain the not working a little more.
--
Hope this helps
Martin Fishlock, Bangkok, Thailand
Please do not forget to rate this reply.


"T. Valko" wrote:

=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