Conditional Formatting - How to Highlight cells in a row (Up to 5) if they have consecutive "ascending" numbers with different colors based on the matching criteria.
For example:
Sequence Numbers (50,57,58,60,70), (101,102,103,200,205), (300, 402,403,404,405) and (7,8,9,10,11)
If 2 consecutive numbers are found, consecutive numbers are highlighted GREEN (50,57,58,60,70)
If 3 consecutive numbers are found, consecutive numbers are highlighted YELLOW (101,102,103,200,205)
If 4 consecutive numbers are found, consecutive numbers are highlighted ORANGE (300, 402,403,404,405)
If 5 consecutive numbers are found, consecutive numbers are highlighted RED (7,8,9,10,11)
If color coding to this extent is not a possibility, at least highlight the consecutive numbers with one color.
Thank you in Advance,
Renne
For example:
Sequence Numbers (50,57,58,60,70), (101,102,103,200,205), (300, 402,403,404,405) and (7,8,9,10,11)
If 2 consecutive numbers are found, consecutive numbers are highlighted GREEN (50,57,58,60,70)
If 3 consecutive numbers are found, consecutive numbers are highlighted YELLOW (101,102,103,200,205)
If 4 consecutive numbers are found, consecutive numbers are highlighted ORANGE (300, 402,403,404,405)
If 5 consecutive numbers are found, consecutive numbers are highlighted RED (7,8,9,10,11)
If color coding to this extent is not a possibility, at least highlight the consecutive numbers with one color.
Thank you in Advance,
Renne