If or conditional formating

Experts,
I need help on this conditional formating

If M6< or M6> then apply formating
Frank FreeseAsked:
Who is Participating?
 
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
 
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
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
Frank FreeseAuthor Commented:
ok - ignore any errors - concentrate of range M6:M83
Book2.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
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.