Still struggling with border

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
Click to expand...

Condition 1 = 0
Condition 2 = ""

Border, not grid....
 
Mauro,

Thank you for your response, I tried it and it still does
not work. The cell is blank but the border remains.
 
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.
 
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.
 
Thank you for your response, I tried it and it still does
not work. The cell is blank but the border remains.
Click to expand...
Maybe your cell(s) has all around
cells with borders.....
 
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.




.
Click to expand...
 
Back
Top