Create Rule on Conditional Formatting

NNOG28

New Member
Joined
Feb 28, 2019
Messages
11
I would like to know how I can create rule to highlight when column A - b > 50, and <-50
Column Acolumn B
300350
200201
15050

<tbody>
</tbody>


<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
I tried this, but it did not work
=OR(AND((A2-B2)>50,(A2-B2)<-50))

TIA..
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
12,404
Office Version
365, 2010
Platform
Windows, Mobile
I would like to know how I can create rule to highlight when column A - b > 50, and <-50
Can you explain your criteria again as it can't be both greater than 50 and less than -50 as there will never be a match?

Maybe you meant greater than -50 and less than 50?
 
Last edited:

NNOG28

New Member
Joined
Feb 28, 2019
Messages
11
I want to compare the change of the numbers between 2 weeks. Let's say I am comparing store count of this year and last year on each product. and I want to highlight on this year number whenever it is 50 more store counts than last year, or highlight if it is 50 less store counts than last year.

Does it make sense?
 

MARK858

MrExcel MVP
Joined
Nov 12, 2010
Messages
12,404
Office Version
365, 2010
Platform
Windows, Mobile
Then you just need the OR not the AND...

Excel Workbook
AB
1Column Acolumn B
2300350
3200201
415050
5300351
Sheet4
#VALUE!
 

NNOG28

New Member
Joined
Feb 28, 2019
Messages
11
It worked ... thank you so much

Then you just need the OR not the AND...

Sheet4

AB
1Column Acolumn B
2300350
3200201
415050
5300351

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:142px;"><col style="width:142px;"></colgroup><tbody>
</tbody>

Conditional formatting
CellNr.: / ConditionFormat
A21. / Formula is =OR(A2-B2>50,A2-B2<-50)Abc
A31. / Formula is =OR(A2-B2>50,A2-B2<-50)Abc
A41. / Formula is =OR(A2-B2>50,A2-B2<-50)Abc
A51. / Formula is =OR(A2-B2>50,A2-B2<-50)Abc

<tbody>
</tbody>

<tbody>
</tbody>


Excel tables to the web >> Excel Jeanie HTML 4
 

Watch MrExcel Video

Forum statistics

Threads
1,095,750
Messages
5,446,271
Members
405,393
Latest member
sully361

This Week's Hot Topics

Top