I need a conditional formatting formula
Posted on 2014-01-15
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.