Solved

If or conditional formating

Posted on 2011-02-11
7
309 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
ID: 34873505
Please upload your file.

Patrick
0
 
LVL 59

Expert Comment

by:Saurabh Singh Teotia
ID: 34873514

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
ID: 34873541
ok - ignore any errors - concentrate of range M6:M83
Book2.xlsx
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 59

Accepted Solution

by:
Saurabh Singh Teotia earned 500 total points
ID: 34873587
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
ID: 34873959
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
ID: 34874019

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
ID: 34874192
thanks ... much appreciated
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

912 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

16 Experts available now in Live!

Get 1:1 Help Now