I have 100,000 records in a table (data) in sheet 1 as per below based on "Success" or "Fail"
Table (data)
Event Result
MB65 Success
B65 (AI) Success
MF6.1.1.1.3 Fail
MF6.1.1.1.3.1 Fail
MF6.1.1.1 Fail
I need to colour a row based on another table (_MF6) which has 22 possible events - in this case only row containing "MF6.1.1.1.3.1" would be coloured as it is a "Fail"
Table _MF6
MF6.1.1.1.3.1
MF6.1.1.1.3.2
MF6.1.1.1.3.3
MF6.1.1.1.4.1
MF6.1.1.1.4.2
MF6.1.1.1.4.3
etc
Table (data)
Event Result
MB65 Success
B65 (AI) Success
MF6.1.1.1.3 Fail
MF6.1.1.1.3.1 Fail
MF6.1.1.1 Fail
I need to colour a row based on another table (_MF6) which has 22 possible events - in this case only row containing "MF6.1.1.1.3.1" would be coloured as it is a "Fail"
Table _MF6
MF6.1.1.1.3.1
MF6.1.1.1.3.2
MF6.1.1.1.3.3
MF6.1.1.1.4.1
MF6.1.1.1.4.2
MF6.1.1.1.4.3
etc