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

If or conditional formating

Experts,
I need help on this conditional formating

If M6< or M6> then apply formating
0
Frank Freese
Asked:
Frank Freese
  • 3
  • 3
1 Solution
 
patrickabCommented:
Please upload your file.

Patrick
0
 
Saurabh Singh TeotiaCommented:

Assuming the value that you are comparing is 10 and 15 then you can simply use this...

=OR(M6<10,M6>15)

Saurabh...
0
 
Frank FreeseAuthor Commented:
ok - ignore any errors - concentrate of range M6:M83
Book2.xlsx
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
Saurabh Singh TeotiaCommented:
There you go..I applied the formula when the value is Zero and the value is more then 10...It will do what you are looking for...

Saurabh...
Book2-1-.xlsx
0
 
Frank FreeseAuthor Commented:
Saurabh,
You got it - but I have a question. =Or(M6<0,M6>0) from $M$6:$M$83
How does this condition relate to other cell references, M29, for example if the formula is M6?
0
 
Saurabh Singh TeotiaCommented:

Dont worry if you apply this formula on entire range and remove the dollar sign like the way i have done in the enclosed workbook. it automatically adjust the range.
0
 
Frank FreeseAuthor Commented:
thanks ... much appreciated
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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