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]

[TABLE="width: 662"]
<colgroup><col><col span="4"><col></colgroup><tbody>[TR]
[TD][TABLE="width: 662"]
<colgroup><col><col span="4"><col></colgroup><tbody>[TR]
[TD] [/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]

LATENT

[/TD]
[TD]EMERGING [/TD]
[TD]ESTABLISHED
[/TD]
[TD]ADVANCED

[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD](Q1, Q2)
[/TD]
[TD](Q1, Q2) [/TD]
[TD](Q1, Q2) [/TD]
[TD](Q1, Q2)
[/TD]
[TD]Established[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD](Q3) [/TD]
[TD](Q3) [/TD]
[TD](Q3) [/TD]
[TD](Q3) [/TD]
[TD]Established[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD](Q5) [/TD]
[TD](Q5,Q6) [/TD]
[TD](Q5,Q6) [/TD]
[TD](Q5,Q6,Q7) [/TD]
[TD]Advanced[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD](Q8)[/TD]
[TD](Q8)[/TD]
[TD](Q8)[/TD]
[TD](Q8)[/TD]
[TD]Latent[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD](Q9)[/TD]
[TD](Q9)[/TD]
[TD](Q9)[/TD]
[TD](Q9)[/TD]
[TD]Emerging[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="colspan: 4"][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
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?