First of all, apologize if this is a stupid question.
I looked everywhere and I can only find multiple formulas working exactly the opposite of my desired result:
All the cells I am working on, have a formula in it. Using conditional formatting, I want to highlight only the cells which are returning a value other than zero.
These formulas below, are highlighting the cells with zero value, instead of the ones with value other than zero:
=AND(A1=0;A1<>"")
=AND(A1=0;LEN(A1)>0)
Thanks!
I looked everywhere and I can only find multiple formulas working exactly the opposite of my desired result:
All the cells I am working on, have a formula in it. Using conditional formatting, I want to highlight only the cells which are returning a value other than zero.
These formulas below, are highlighting the cells with zero value, instead of the ones with value other than zero:
=AND(A1=0;A1<>"")
=AND(A1=0;LEN(A1)>0)
Thanks!