Color Coding Based on Another Cell Content and Copy Conditional Format

Hi guys, I need to do a couple of things with my excel spreadsheet.

First of all I have to color a matrix of cells based on the content of another cell.
After I did that I want to reproduce, the matrix and the conditional format, based on another one cell, without do all the work again.
Since I understand my english is terrible, I included an example spreadsheet with the instructions.

I apologize for my language
Best
Matthew

Unfortunately that's not going to help but ty a lot for your time anyway

What you are suggesting to do is to conditional formatting a cell based on its value, while I need to format it based on another one.
Also another problem I'm going to have is to reproduce the conditional format. When you copy and paste a cell in excel, by defaul, the formatting, is going to be the same, along with the condition of color format. The problem is that conditional formatting is going to be based on the old expressions

Try ..

as CF rule..

=OR(E6=LEFT($O$2,1),E6=MID($O$2,3,1),E6=RIGHT($O$2,1))

Hi, ty for stopping by.
Well, I tried on the example spreadsheet and it works, however, it was semplification of the real sheet and on it, it doesnt' work.
What I find that it isn't working is with 2 letter string.

I've included the real spreadsheet so you can figure out why it isn't working. Sorry for taking your time again

I split the string into individual cells

then used

=OR(T5=$BG$4,T5=$BH$4,T5=$BI$4,T5=$BJ$4,T5=$BK$4,T5=$BL$4)

Clearly I am retarded... I can't get that working.
I selected the matrix and then input the conditional format rule, but doesn't work

Tony's formula works fine.

However, note that the numbers 22, 33, 99 are TEXT in your (red) matrix so ensure they are text in the individual cells that contains your parameters (BG4 to BL4)

I want to apologize first, since I'm more than sure you have dealt with this kind of stupid questions before.

If I'm understanding right, I have to split the string into individual cells and I did that but the red matrix didn't change its colors.
Can you edit my example spreadsheet in order do see what I'm doing wrong?

Also I want to point out a thing, the string which I based my color coding is changing in lenght, so I can't split its content everytime. Much of the times I have a very long string so it's pretty akward to do it, any workaround for this?

Again ty for your kind help

See attached:

in BG4

=TRIM(MID(SUBSTITUTE(SUBSTITUTE($BF$4," ",""),",",REPT(" ",99)),(COLUMNS($A:A)-1)*99+1,99))

Copy across row

Changes to Bf4 should be reflected in the row

I copied to CZ4 and named the range "CF_Rng" then used Tony's formula

=OR(CF_rng=T5)

Ty a lot, your solution is great, a couple of probably stupid questions

1. How can I add more columns to the expression? I need 169 at maximum. Should I change the original formula:
=TRIM(MID(SUBSTITUTE(SUBSTITUTE($BF$4," ",""),",",REPT(" ",99)),(COLUMNS($A:A)-1)*99+1,99))
in
=TRIM(MID(SUBSTITUTE(SUBSTITUTE($BF$4," ",""),",",REPT(" ",169)),(COLUMNS($A:A)-1)*168+1,169))
?
Right now I copied the formula across the row including more cells, but I don't know whether I should change those numbers


2. =OR(CF_rng=T5)
I made a custom range named 'porco' after that I modify the expression to =OR(porco=AK10) in order to color another table, but it doesn't work.
Instead if I use the expression =OR(porco=T5) works, I don't understand why, what is T5?

See the update spreadsheet

Ty a lot for your work, I'll try it as soon sa I get home