Still struggling with border

[Guest]

I wrote before and asked if I have a cell with a border
around it and if the value of the cell is blank or 0, I
would like the border to disappear. I thought it worked
when I tried conditional formatting, but it doesn't. I
may be using an incorrect formula, can you help?

 

[Mauro Gamberini]

I wrote before and asked if I have a cell with a border

around it and if the value of the cell is blank or 0, I
would like the border to disappear. I thought it worked
when I tried conditional formatting, but it doesn't. I
may be using an incorrect formula, can you help?

Condition 1 = 0
Condition 2 = ""

Border, not grid....

 

[Guest]

Mauro,

Thank you for your response, I tried it and it still does
not work. The cell is blank but the border remains.

 

[Guest]

Hi

Make sure there is no space between your "" signs. As an alternative, try:
Formula is =OR(A1=0,A1="")
but replace A1 with your cell reference. Once you have entered this, set
your format to no border.

 

[Govind]

Hi,

Go to conditional formatting, and give the condition that
if formula is =OR(A1<=0,A1="") then click on format and choose no
border. (change A1 to the cell where you needs the formatting)

You will not have any border when the cell is 0 or blank

Govind.

 

[Mauro Gamberini]

Thank you for your response, I tried it and it still does

not work. The cell is blank but the border remains.

Maybe your cell(s) has all around
cells with borders.....

 

[Guest]

You are the best!!! Thank you very much!

-----Original Message-----
Hi,

Go to conditional formatting, and give the condition that
if formula is =OR(A1<=0,A1="") then click on format and choose no
border. (change A1 to the cell where you needs the formatting)

You will not have any border when the cell is 0 or blank

Govind.




.

 

[Guest]

Thank you so much!!! It's working!! You're the best!