• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 348
  • Last Modified:

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.
0
wrt1mea
Asked:
wrt1mea
  • 3
  • 2
  • 2
1 Solution
 
wrt1meaAuthor Commented:
=IFERROR(('Wells'!O10),"") : should be =IFERROR(('Wells'!N1),"")
0
 
NorieCommented:
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
 
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Danny ChildIT 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
 
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
 
NorieCommented:
So were they text as I suggested?
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 3
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now