Frank Freese

asked on

# If or conditional formating

Experts,

I need help on this conditional formating

If M6< or M6> then apply formating

I need help on this conditional formating

If M6< or M6> then apply formating

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

=OR(M6<10,M6>15)

Saurabh...

ASKER

ok - ignore any errors - concentrate of range M6:M83

Book2.xlsx

Book2.xlsx

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

ASKER

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?

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?

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.

ASKER

thanks ... much appreciated

Patrick