#### Emerlin

##### Board Regular

- Joined
- Jan 8, 2007

- Messages
- 105

Hi, I have a formula where I am checking if a cell is blank = if(a1="","",do math)

I am then applying conditional formatting to cells above a number. Any of the cells that are true or "", get applied that conditional formatting even thought it is blank.

Any ideas? I do not want "0" to show in all these cells.

Thanks.

I am then applying conditional formatting to cells above a number. Any of the cells that are true or "", get applied that conditional formatting even thought it is blank.

Any ideas? I do not want "0" to show in all these cells.

Thanks.

Last edited: