Solved

If or conditional formating

Posted on 2011-02-11
7
308 Views
Last Modified: 2012-06-22
Experts,
I need help on this conditional formating

If M6< or M6> then apply formating
0
Comment
Question by:Frank Freese
  • 3
  • 3
7 Comments
 
LVL 45

Expert Comment

by:patrickab
Comment Utility
Please upload your file.

Patrick
0
 
LVL 59

Expert Comment

by:Saurabh Singh Teotia
Comment Utility

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

=OR(M6<10,M6>15)

Saurabh...
0
 

Author Comment

by:Frank Freese
Comment Utility
ok - ignore any errors - concentrate of range M6:M83
Book2.xlsx
0
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
LVL 59

Accepted Solution

by:
Saurabh Singh Teotia earned 500 total points
Comment Utility
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
 

Author Comment

by:Frank Freese
Comment Utility
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
 
LVL 59

Expert Comment

by:Saurabh Singh Teotia
Comment Utility

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
 

Author Closing Comment

by:Frank Freese
Comment Utility
thanks ... much appreciated
0

Featured Post

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now