Conditional Formatting

[gtd526]

Hello,
I'm looking to highlight cells that match in value, in pairs of 2. 4&5, 6&7, 8&9, 10&11, 12&13, etc.
Thank you.

NFL.xlsm
	W
4	50%
5	58%
6	58%
7	58%
8	33%
9	42%
10	17%
11	58%
12	67%
13	42%
Weekly Picks

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
W4:W35	Cell Value	top 1 values	text	NO
W4:W35	Cell Value	top 3 bottom values	text	NO
W4:AB35	Expression	=W4=MAX(OFFSET(W$4,FLOOR(ROW(W4)-ROW(W$4),2),0,2,1))	text	NO

 

[6StringJazzer]

Your example does not seem to match what you are describing. What kind of highlighting do you want on the matching pairs, since you already have a bunch of highlighting you are applying?

You will need two rules. Each one applies to the range W4:W35.

=AND(ISEVEN(ROW(W4)),W4=W5)

=AND(ISODD(ROW(W4)),W4=W3)

 

[gtd526]

Your example does not seem to match what you are describing. What kind of highlighting do you want on the matching pairs, since you already have a bunch of highlighting you are applying?

You will need two rules. Each one applies to the range W4:W35.

=AND(ISEVEN(ROW(W4)),W4=W5)

=AND(ISODD(ROW(W4)),W4=W3)

Works perfectly. I just wanted to highlight the matches in a different color, but I was having trouble to match the pair.
thank you.

 

[6StringJazzer]

You are welcome!