Color the columns based on group and column value

I am using excel 2016, where I need to do some coloring based on group and a value in a particular column.

My input record is given below

COLA COLB COLC COLD COLE COLF COLG COLH COLI
100 45.6 MP 1 AA DD xxxx xxxx xxxx
100 44.7 DA 1 DE DD xxxx xxxx xxxx
100 43.4 CP 1 DFFF DFFF xxxx xxxx xxxx
121 33.45 MP 1 AA DD xxxx xxxx xxxx
121 33.45 DA 1 DE DD xxxx xxxx xxxx
121 33.45 DA 1 DFFF DFFF xxxx xxxx xxxx
234 23.54 MP 2 DE DD xxxx xxxx xxxx
234 12.34 CP 2 DFFF DFFF xxxx xxxx xxxx

My expected output is that I need to put the color the rows with COLA values 100 and 234, as this row group contain value "CP" in COLC

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

Select the entire range to highlight

Conditional Formatting
New Rule
Use a formula to determine...

=AND(OR(A2=100,A2=234)*COUNTIF(C$2:C$11,"CP")>0)

format as required

You need to be a little more specific, my solution reflects the file you provided.
Maybe provide some more examples?

Try this CF formula

=MATCH(A2,IF(C$2:C$11="CP",A$2:A$11),0)>0

Just paste the below formula into the "format values where this formula is true" box, it does accept =

The formula was wrong, it only highlighted column A.
It should be

=MATCH($A2,IF($C$2:$C$11="CP",$A$2:$A$11),0)>0

Just paste the below formula into the "format values where this formula is true" box, it does accept =

The formula was wrong, it only highlighted column A.
It should be

=MATCH($A2,IF($C$2:$C$11="CP",$A$2:$A$11),0) > 0

I am still facing some issue, I have attached the error below

Don't mess about with the OP. It just gets confusing.

Here you go

If it works on a smaller set of data then it sounds like the larger data needs looking at.

Post a sample of the data where it's not working (in a file so the data can be examined).