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?