Conditional Formatting with a Twist

[mminchev]

Hi Everyone,

I need some help with conditional formatting.

Here is the table that I need to put conditional formatting highlights in!

Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7	Week 8	Week 9	Week 10	Week 11	Week 12
116%	158%	125%	107%	170%	164%	127%	119%	117%	243%	146%	169%
52%	108%	125%	142%	116%	128%	105%	104%	0%	226%	0%	114%
134%	177%	120%	167%	236%	0%	0%	157%	122%	135%	152%	147%

<colgroup><col width="64" style="width: 48pt;" span="12"> <tbody> </tbody>

So what I need the conditional formatting to do is to highlight all cells that have a difference of 25% or -25% or more between each other.

So for example:

Week 2 - Week 1 = 42% so Cell B3 (158%) should be highlighted.

Does anyone know what kind of an IF Statement I need for this?

Thank you!

 

[etaf]

B3 is comparing to B2
What about the other rows

are you only comparing on the same row
B2 = 116
B3 = 158 - so B3 highlights
B4 = 125 - B4 highlights
B5 = 107 - no highlight
B6 = 170 - Highlights
B7 = 164 - no
B8 = 127 - highlights

is that correct ?

If so - see next post

=OR(C2-B2>0.25, C2-B2<-0.25)

 

[etaf]

removed

 

[etaf]

Excel Workbook
	B	C	D	E	F	G	H	I	J	K	L	M
1	Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7	Week 8	Week 9	Week 10	Week 11	Week 12
2	116%	158%	125%	107%	170%	164%	127%	119%	117%	243%	146%	169%
3	52%	108%	125%	142%	116%	128%	105%	104%	0%	226%	0%	114%
4	134%	177%	120%	167%	236%	0%	0%	157%	122%	135%	152%	147%
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C2	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
D2	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
E2	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
F2	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
G2	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
H2	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
I2	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
J2	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
K2	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
L2	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
M2	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
C3	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
D3	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
E3	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
F3	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
G3	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
H3	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
I3	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
J3	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
K3	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
L3	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
M3	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
C4	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
D4	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
E4	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
F4	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
G4	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
H4	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
I4	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
J4	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
K4	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
L4	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc
M4	1. / Formula is =OR(C2-B2>0.25, C2-B2<-0.25)	Abc

 

[mminchev]

Thanks for the help, I guess in my head I overcomplicated it, this really helped! I appreciate it