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