Conditional Formatting of empty cells?

  • Thread starter Thread starter CliffHanger9
  • Start date Start date
C

CliffHanger9

i m makin a form with alot of stuff goin on and i want to make it ver
easy for ppl to fill it in...

ssssoooo....

is there a way to apply conditional formatting to empty/blank/nul
cells


i m looking ideally for something that will highlight the cell wit
like a yellow background color so that it stands out but it has to g
back to no fill wen they enter the info

if anyone has any solutions or advice on this that would rock

-thanks :
 
put this in the conditional format for the cell

formula is... =$a$1=""

as long as A1 is blank A1 will have the conditional format
 
thanks for the rapid reply...

is it at all possible to do a range of cells?

i tried it but...yea i m new to this conditional formatting bit

like i said this form is full of stuff and if i could just specify
range and have the ones that were blank be yellow unitl it gets fille
in that would be ideal

thanks though! :
 
If you wanted to distinguish a cell that really empty from
one that had a space in it you could check as follows:

Looks Blank or ISBLANK -- the equivalent VBA formula is ISEMPTY
=TRIM(A1)="" -- looks blank
=ISBLANK(A1) -- actually is blank, no constants no formulas
=TRIM(A1)<>"" -- does not look blank
=NOT(ISBLANK(A1)) -- actually not blank, may contain formulas

I have a page on Conditional Formatting
http://www.mvps.org/dmcritchie/excel/condfmt.htm

The formula you create for Conditional Formatting is based on the
cell that is currently active. The cells affected (to be colored) are those
in the Selection Range. This distinction is very important to being able to
understand and use Conditional Formatting.
 
Back
Top