CONDITIONAL FORMATING!!!!!

F

FC

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
 
T

T. Valko

Try this:

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

Biff
 
F

FC

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

Sunday88310

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
 
M

Martin Fishlock

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.
 
T

T. Valko

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.
Click to expand...

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
 
Top