gtd526
Well-known Member
- Joined
- Jul 30, 2013
- Messages
- 660
- Office Version
- 2019
- Platform
- Windows
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.
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.
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 |