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