CONDITIONAL FORMATING!!!!!
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
|