Thanks for your response Gord. I figured it out by a combination of all the
replies. All of them as a single comment where confusing but put together
they made sense, thanks.

"Gord Dibben" wrote:

FormatConditional FormattingFormula is:

=NOT(ISBLANK(cellref))

FormatBorder


Gord Dibben MS Excel MVP

On Wed, 30 Apr 2008 15:21:00 -0700, Adrian
wrote:

Is there a way to utomatically remove boarder if there is no value in the
cell and place a boarder i there is?