Select the cell or cells you want this functionality on (if you select more
than one cell, note which one is the active cell) and click
Format/Conditional Formatting in Excel's menu bar. On the dialog box that
appears, select "Formula Is" from the first drop down and put this formula
in the second field...

=LEN(A1)0

NOTE: Change the A1 reference to the address of the cell (or, in the case of
multiply selected cells, the address for the active cell).

Next, click the Format button and then select the Border tab on the next
dialog box that appears. Select the type of outlining you want (you can also
select other format options from the other tabs if you wish) and then OK
your way back to the worksheet. Whenever you enter something into that cell
(or one of the cells from the multiple selection), the border option you
picked will appear.

Rick


"Adrian" wrote in message
...
Is there a way to utomatically remove boarder if there is no value in the
cell and place a boarder i there is?