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

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

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

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

=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

I have used both formulas and they both work fine.
What I wanted to say is that if you select a "range" then give the formula
the range name in eitor of the conditional foumulas provided, =ISBLANK(Range
Name)=True or =COUNTA(Range Name)=0 then anyware in that range the color
will change :)


William<"M"
Using 2007


"FC" wrote:

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

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

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