can I make Blank cells a color?
 

Hi,
excel 2003, is their a filter, or way, to have a column formatted so that if
thier i no info in the cell it is distinguishable immediately, like a color
maybe? Just give me the crumbs and I will be happy to do the research and
learn.
Thanks
Frank

Look at Format|Conditional formatting

spoiler alert....

..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
..
Select the column (Say column C).
with C1 the activecell in the selection
format|conditional formatting
formula is: =C1=""
click on the Format... button
choose the format you want
(I'd use the pattern tab and a nice color)


Frank wrote:

Hi,
excel 2003, is their a filter, or way, to have a column formatted so that if
thier i no info in the cell it is distinguishable immediately, like a color
maybe? Just give me the crumbs and I will be happy to do the research and
learn.
Thanks
Frank

--

Dave Peterson

One way via conditional formatting ..

Try this:
Press CTRL+A (this selects the entire sheet)

Click Format Conditional Formatting

Under Condition 1, set it as:
Formula is| =NOT(ISBLANK(A1))
Click Format button Patterns tab Light green? OK

Click OK at the main dialog

Now test it out, enter anything in any cell on the sheet
The cell will be filled with the light green color
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Frank" wrote in message
...
Hi,
excel 2003, is their a filter, or way, to have a column formatted so that
if
thier i no info in the cell it is distinguishable immediately, like a
color
maybe? Just give me the crumbs and I will be happy to do the research and
learn.
Thanks
Frank

Oops ! Had it the other way round ..
Just change the cond format formula to: =ISBLANK(A1)
if you want to fill blank cells (as per post)

Now when you enter anything in any cell,
the cell will become "colourless" (i.e. the default "no fill" color)
(or it'll just assume the normal fill color applied, if done)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

Another potential problem,
you would want to select cell A1 before using Ctrl+A
so that A1 is the activecell that the formula is based on. Without
that bit of information the Original Poster will wonder why C.F. works
great sometimes and fails at other times.
http://www.mvps.org/dmcritchie/excel/condfmt.htm

"Max" wrote in message
Oops ! Had it the other way round ..
Just change the cond format formula to: =ISBLANK(A1)
if you want to fill blank cells (as per post)

Now when you enter anything in any cell,
the cell will become "colourless" (i.e. the default "no fill" color)
(or it'll just assume the normal fill color applied, if done)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

Thanks so much to all of you guys and gals. This is one of the most "quick
and understandable response" NG's I have been to. Really great!
Frank

"David McRitchie" wrote in message
...
Another potential problem,
you would want to select cell A1 before using Ctrl+A
so that A1 is the activecell that the formula is based on. Without
that bit of information the Original Poster will wonder why C.F. works
great sometimes and fails at other times.
http://www.mvps.org/dmcritchie/excel/condfmt.htm

"Max" wrote in message
Oops ! Had it the other way round ..
Just change the cond format formula to: =ISBLANK(A1)
if you want to fill blank cells (as per post)

Now when you enter anything in any cell,
the cell will become "colourless" (i.e. the default "no fill" color)
(or it'll just assume the normal fill color applied, if done)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

David, thanks. Good point there about ensuring
that cell A1 is selected before using Ctrl+A

Frank - you're welcome !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--