Please see the attached and let me know if you can work with that?

I've used conditional formatting with a similar formula used in your table, this works off there being certain text within the example conditons (see column E)

Test_tracker_example_V2.xlsx