Conditional formatting- Checkbox tied to partial string lookup

[chemjimps]

Trying to get a check box, which is linked to the cell concealed behind it, to have conditional formatting so that when the check box is clicked the value 2 cells to the right (which is a partial string) will be highlighted throughout the schedule. I was thinking this could be done by having conditional formatting recognize when the linked cell reads "TRUE" it would do an array search, but I have had no luck in getting this to work.

 

[chemjimps]

I suppose the question is also; Is this possible with non-VBA application? If not, I am not familiar enough with writing VBA to know how to do this.