Conditional Formatting Without Six Helper Columns

what I try to do: Table57 changes color automatically by 3 tables on the right, ABC takes color from Table15, ABC takes bold from Table17 and DEF takes color from Table16.


I have a worksheet based on lists and Conditional Formatting, the problem is that I could not do that without using columns P,Q,R,S,T,U and hide the data in these cells.
there is any way to do that without using these cells, any way to do it cleaner?

In addition, can you explain to me why this Conditional Formatting not working?

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. As you are new here, I have done it for you this time.)

Yes, because I have changed it for you. This has nothing to do with your English, which is fine - it's to do with making thread titles useful and informative rather than vague and generic.