Conditional formatting (highlighting) can do this.
Instead of the three numbers being ina single cell (I1), put them in 3 separate cells (I used J1,J2,J3) then select a range (any width) starting on row 4, going as far down as necessary, then add conditional formatting with the formula:
=OR(AND($N4=$J$1,$N5=$J$2,$N6=$J$3),AND($N3=$J$1,$N4=$J$2,$N5=$J$3),AND($N2 =$J$1,$N3=$J$2,$N4=$J$3))
This will highlight all sets of three rows. See attached where I've only formatted column M.
p45cal Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Reply With Quote