wrt1mea
asked on
I need a conditional formatting formula
I am trying to format a production worksheet. I have the production sheet linked to my working sheet with the followin formula : =IFERROR(('Wells'!O10),"") so that it doesnt return any zeroes.
I am trying to use conditional formatting based on a number that is return by the formula above. The number is a 7 digit accounting number in Column N. Not having much luck using >0 >100, >1000, etc.
I need to return conditional formatting if there is a number greater than zero in N1.
I am trying to use conditional formatting based on a number that is return by the formula above. The number is a 7 digit accounting number in Column N. Not having much luck using >0 >100, >1000, etc.
I need to return conditional formatting if there is a number greater than zero in N1.
Change the fomula to this,
=IFERROR(('Wells'!O10),"")
and format the cell so 0s aren't shown.
If that doesn't work it might be worth checking if the account numbers are actually numbers and not numbers stored as text.
=IFERROR(('Wells'!O10),"")
and format the cell so 0s aren't shown.
If that doesn't work it might be worth checking if the account numbers are actually numbers and not numbers stored as text.
ASKER
The formula for returning values in the N1 cell work like they are supposed to. They either return a blank or a number (accounting code). I am trying to set my conditional formatting up to see if the cell has an accounting code number in it or not.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
another way to remove zero values is to apply a regular Custom format of
0;-0;
0;-0;
ASKER
GREAT! THANKS!
So were they text as I suggested?
ASKER