Create Rule on Conditional Formatting

[NNOG28]

I would like to know how I can create rule to highlight when column A - b > 50, and <-50
[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl66, width: 64"][TABLE="width: 500"]
<tbody>[TR]
[TD]Column A[/TD]
[TD]column B[/TD]
[/TR]
[TR]
[TD]300[/TD]
[TD]350[/TD]
[/TR]
[TR]
[TD]200[/TD]
[TD]201[/TD]
[/TR]
[TR]
[TD]150[/TD]
[TD]50[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[TD="class: xl67, width: 64"][/TD]
[/TR]
</tbody>[/TABLE]
I tried this, but it did not work
=OR(AND((A2-B2)>50,(A2-B2)<-50))

TIA..

 

[MARK858]

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?

 

[NNOG28]

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]

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

Excel Workbook
	A	B
1	Column A	column B
2	300	350
3	200	201
4	150	50
5	300	351
Sheet4

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2	1. / Formula is =OR(A2-B2>50,A2-B2<-50)	Abc
A3	1. / Formula is =OR(A2-B2>50,A2-B2<-50)	Abc
A4	1. / Formula is =OR(A2-B2>50,A2-B2<-50)	Abc
A5	1. / Formula is =OR(A2-B2>50,A2-B2<-50)	Abc

 

[NNOG28]

It worked ... thank you so much

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

Sheet4

	A	B
Column A	column B

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:142px;"><col style="width:142px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]
[TD="align: right"]300[/TD]
[TD="align: right"]350[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]3[/TD]
[TD="align: right"]200[/TD]
[TD="align: right"]201[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]4[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: right"]150[/TD]
[TD="align: right"]50[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]5[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: right"]300[/TD]
[TD="align: right"]351[/TD]

</tbody>

Conditional formatting

Cell Nr.: / Condition Format A2 1. / Formula is =OR(A2-B2>50,A2-B2<-50) <tbody> [TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] "]Abc

<tbody>

A3	1. / Formula is =OR(A2-B2>50,A2-B2<-50)
A4	1. / Formula is =OR(A2-B2>50,A2-B2<-50)
A5	1. / Formula is =OR(A2-B2>50,A2-B2<-50)

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] "]Abc[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] "]Abc[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] "]Abc[/TD]

</tbody>

[/TD]

</tbody>

Excel tables to the web >> Excel Jeanie HTML 4