Add border automatically

[scouse13]

Hi all, I have tried playing about with Conditional formatting and recording a macro to see code, but just end up baffled, here's what I am trying to achieve,

if cell B10 has data entered into it, i would like the range of cells B10 to J10 to have a bottom edge border appear Automatically, if the data in B10 is cleared then the border on the range of cells also is removed.

i Hope this is clear

many thanks

Scouse13

[Richard Buttrey]

Hi

Select B10 and enter the conditional format

Please Login or Register  to view this content.

pick the underline format and and apply the CF to B10:J10

[DMA]

Hi scouse13
Add this code to your sheet.

Please Login or Register  to view this content.

[scouse13]

Thanks Richard works a treat

[scouse13]

Thanks DMA, also works a treat