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.
LVL 1
wrt1meaAsked:
Who is Participating?
 
Danny ChildConnect With a Mentor IT ManagerCommented:
you may need to use the formula:
=Value(O2)>1000
 - if your data values are actually text.

Example attached with 3 rules specified.
ee---condit-formatting.xlsx
0
 
wrt1meaAuthor Commented:
=IFERROR(('Wells'!O10),"") : should be =IFERROR(('Wells'!N1),"")
0
 
NorieVBA ExpertCommented:
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.
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
wrt1meaAuthor Commented:
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.
0
 
Danny ChildIT ManagerCommented:
another way to remove zero values is to apply a regular Custom format of
0;-0;
0
 
wrt1meaAuthor Commented:
GREAT! THANKS!
0
 
NorieVBA ExpertCommented:
So were they text as I suggested?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.