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?