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
|