View Single Post
  #3   Report Post  
Max
 
Posts: n/a
Default

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