Formating cells

[Adrian]

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

 

[DazzaData]

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

 

[Rick Rothstein \(MVP - VB\)]

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

 

[Gord Dibben]

Format>Conditional Formatting>Formula is:

=NOT(ISBLANK(cellref))

Format>Border


Gord Dibben MS Excel MVP

 

[Adrian]

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

 

[Adrian]

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

 

[Adrian]

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.