Conditional formatting, yes or no?

[Drrellik]

I am creating a small one page data table and dont mind rearranging it to fit the formula(s) or formats

On the sheet I will only change the value in D1 from A to B,C or D
based on one of four inputs have the table on the left range A1:C12 highlighted based on the data in the corresponding column to my selection

for this one I chose A for Column E2:E10

I would actually like some suggestions or how you would create something like this, just a nudge in the right direction and not so much a shove...

thanks in advance for your thoughts or hints.

~DR

Book1
	A	B	C	D	E	F	G	H
1	1	2	3	A	A	B	C	D
2	4	5	6		1	2	7	8
3	7	8	9		3	4	9	10
4	10	11	12		5	6	11	12
5	13	14	15		13	14	17	18
6	16	17	18		15	16	20	19
7	19	20	21		22	21	26	25
8	22	23	24		24	23	28	27
9	25	26	27		34	33	30	29
10	28	29	30		36	35	32	31
11	31	32	33
12	34	35	36
Sheet1

 

[Anonymous1378]

if you just want a hint, use a lookup function that returns a column from E2:H10 based on your input in D1, then compare each cell in A1:C12 to the values of that column.

If you want an answer, the spoiler is there for you.

Spoiler

Book7
	A	B	C	D	E	F	G	H
1	1	2	3	A	A	B	C	D
2	4	5	6		1	2	7	8
3	7	8	9		3	4	9	10
4	10	11	12		5	6	11	12
5	13	14	15		13	14	17	18
6	16	17	18		15	16	20	19
7	19	20	21		22	21	26	25
8	22	23	24		24	23	28	27
9	25	26	27		34	33	30	29
10	28	29	30		36	35	32	31
11	31	32	33
12	34	35	36
Sheet2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:C12	Expression	=MATCH(A1,INDEX($E$2:$H$10,,MATCH($D$1,$E$1:$H$1,0)),0)	text	NO

 

[Drrellik]

Thank you for the push, I was not able to make it work with your conditional formatting, probably because I am not using it correctly but I was able to rearrange the data and make it work another way.

Thank you again