Conditional Formatting highlighting a specific cell in a Row.

[DCAbound]

Hi guys,

Im stuck at what to do? I have a work sheet in which I have to base a response/Users/ehain/Desktop/example.jpeg from L4 to highlight the appropriate cell C4. Such as shown in the image attached. Can any help.

thanks

 

[DCAbound]

B C D E F 2 LATENT EMERGING ESTABLISHED ADVANCED 3 (Q1, Q2) (Q1, Q2) (Q1, Q2) (Q1, Q2) Established 4 (Q3) (Q3) (Q3) (Q3) Established 5 (Q5) (Q5,Q6) (Q5,Q6) (Q5,Q6,Q7) Advanced 6 (Q8) (Q8) (Q8) (Q8) Latent 7 (Q9) (Q9) (Q9) (Q9) Emerging <colgroup><col><col span="4"><col></colgroup><tbody> </tbody>

<colgroup><col><col span="4"><col></colgroup><tbody>
</tbody>

This is the sample worksheet. i need to highlight row d3, d4, e5, b6, c9. Highlights should be because of Column J. Can anyone help?