format cells

[Guest]

I received a spreadsheet which I have to add information to :-
e.g. when it arrived column A is for Ref No.
The first one (A1)was already filled in and had the left and right borders
black and the Ref.No. centred, when I entered my first Ref.No. in the cell
below (A2) the borders automatically went black and the No. I entered was
centred.
How has someone set up the sheet to do this ?
Thanks,

Al

 

[Gord Dibben]

Al

Tools>Options>Edit "Extend list formats and formulas"


Gord Dibben Excel MVP

 

[Guest]

I am very grateful for the very quick reply, but it does not appear to work ?
I have Excel 2003 - Tools > Option > Edit > "Extend data range formats &
formulas" , the check box was ticked already, but when I go down to the next
cell and type e.g. 234 it defaults to right format, and no bold borders ?!
Al

 

[Guest]

Sorry to be a pest - seem to have solved it.

Conditional formatting > if value entered is say between (1 & whatever) then format cells with the border, column was already centre justified so as soon as number is entered it appeared as conditional format

Thanks a lot for your help

Al