View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Nikki
 
Posts: n/a
Default automatically add borders to a cell after entry is complete

you can set a conditional formatting.
Highlight the area you will input numbers

go to format-- conditional Formatting-- cell value is change to not equal
to 0
click on format, select border-- choose one with all borders around it,
click ok and ok again. now if you input any number except 0 you will see the
borders.

hope it help

Nikki

"BKD" wrote:

I've seen this done before. I would like to format the cells in my
spreadsheet to automatically add a border to seperate one cell entry from the
next after I'm finished with the entry. In other words after I tab out of the
cell.

Thanks,
BKD