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