Formating cells

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

Hi,

yes put a border round the cell as normal then use conditional formatting -
cell value is 0 (or use a formula to test if the cell isblank) & set the
conditional format to no border
--
--------------------------------------------
Please reward mine and others efforts - indicating whether our posts were
helpful by clicking the buttons, ta


"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?

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?

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?

Thanks DazzData, did not get what you said. i figured it out eventually, so
thanks for your help.

"DazzaData" wrote:

Hi,

yes put a border round the cell as normal then use conditional formatting -
cell value is 0 (or use a formula to test if the cell isblank) & set the
conditional format to no border
--
--------------------------------------------
Please reward mine and others efforts - indicating whether our posts were
helpful by clicking the buttons, ta


"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?

thanks for your help Rick, was a little confusing at first, but i figured it
out.

"Rick Rothstein (MVP - VB)" wrote:

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?

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?