Dynamically remove borderlines

[thong]

Hello all,

How can I dynamically remove a borderline of a cell if when its empty.

Thank you.

 

[Chihiro]

Since manually set border's will not be overwritten with CF (unless border format is set, ie. can't remove applied border). You will need to check if the cell is not empty then apply CF.

For an example: To apply border to A1 when not empty.
=ISBLANK($A$1)=FALSE
Change Absolute reference as needed (ex: $A1 will allow you to copy CF down and apply to each cell in Col A)

And apply your bordering within CF.

However, there's limited style and weight available for CF border format.

 

[thong]

Hi Chihiro,

Please help me, I cant figure out how to apply it to my file.

Please find attached file.

 

[Chihiro]

Ah, if the value is brought in via formula, ISBLANK() won't work.

You'd need to alter it to check for "". Also note that I've set it up so that if any column for the same row is "", then no border for any. If you want to individually control each column, write separate CF for each column. Or if there should be no border only when there's "" for all 3, then change OR() to AND().

See attached.

 

[thong]

Thanks Chihiro,

works like a charm..