ExcelNewbie2020
Active Member
- Joined
- Dec 3, 2020
- Messages
- 289
- Office Version
- 365
- Platform
- Windows
Experts, is there any way by conditional formatting or by VBA that will solved these.
To highlight cells (3rows) if the value is in numerical sequence (group of 3) but the numbers can be in any order. For example, cells will highlight if the sequence from 1, 2, & 3 will be arranged in any order like 123/132/213/312/231/123/321 please see below. Many thanks
To highlight cells (3rows) if the value is in numerical sequence (group of 3) but the numbers can be in any order. For example, cells will highlight if the sequence from 1, 2, & 3 will be arranged in any order like 123/132/213/312/231/123/321 please see below. Many thanks