I have a spreadsheet usually running several thousand rows that needs to color coded based on whether or not data in a column is in a particular order. If they are, that grouping of 4 rows is a "match" and needs to be colored.
In the attachment, the "Trans Type" column contains the data that needs to be in a specific order. If a group of 4 rows has the following text in order then it needs to be color coded (alternate colors if possible like in the example)
Salary Advance
1608
Salary Advance
Payroll Deduction Taken
If the rows in the spreadsheet do not contain those 4 phrases in that specific order in the "Trans Type" column, it doesn't need to be color coded.
I've a hit a wall and can't figure this out. Any help is appreciated.
Bookmarks