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
|