automatically add borders to a cell after entry is complete

B

BKD

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
 
N

Nikki

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
 
Top