Color a particular cell if ....

[Ultimate Selector]

I want to conditionally format (highlight) a certain cell IF any number in a particular cell in that range is above 3.
My rows go left to right. So in #1 Row, I want the #1 to be Highlighted because the 3.5 is above 3. The #5 would be highlighted as well cause it has two such numbers 3.2 & 3.9 that are above 3.
What is the formula I would use for this in conditional formatting?

Thanks in advance for any help on this issue!

Regards,
U.S.

My example is below.

<colgroup><col style="mso-width-source:userset;mso-width-alt:1954;width:42pt" width="56"> <col style="mso-width-source:userset;mso-width-alt:1954;width:42pt" width="56"> <col style="mso-width-source:userset;mso-width-alt:1954; width:42pt" width="56" span="3"> <col style="mso-width-source:userset;mso-width-alt:1954; width:42pt" width="56" span="5"> </colgroup><tbody>
[TD="class: xl66, width: 56"] [/TD]
[TD="class: xl70, width: 56"] #1 [/TD]
[TD="class: xl70, width: 56"]#2[/TD]
[TD="class: xl70, width: 56"] [/TD]
[TD="class: xl70, width: 56"]#4[/TD]
[TD="class: xl70, width: 56"] #5 [/TD]
[TD="class: xl70, width: 56"]#6[/TD]
[TD="class: xl70, width: 56"]#7[/TD]
[TD="class: xl70, width: 56"]#8[/TD]
[TD="class: xl70, width: 56"]#9[/TD]

[TD="class: xl68"] #1
[/TD]
[TD="class: xl69"]
[/TD]
[TD="class: xl63"]2.1[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"]1.6[/TD]
[TD="class: xl63"]0.9[/TD]
[TD="class: xl63"]1.0[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"]1.9[/TD]
[TD="class: xl63"]3.5[/TD]

[TD="class: xl68"]#2
[/TD]
[TD="class: xl63"]0.5
[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"]0.7[/TD]
[TD="class: xl63"]0.3[/TD]
[TD="class: xl63"]0.5[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"]0.8[/TD]
[TD="class: xl63"]2.0[/TD]

[TD="class: xl68"] [/TD]
[TD="class: xl63"]
[/TD]
[TD="class: xl63"]
[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]

[TD="class: xl68"]#4[/TD]
[TD="class: xl63"]0.6[/TD]
[TD="class: xl63"]1.4[/TD]
[TD="class: xl63"]
[/TD]
[TD="class: xl69"]
[/TD]
[TD="class: xl63"]0.6[/TD]
[TD="class: xl63"]0.6[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"]1.2[/TD]
[TD="class: xl63"]2.1
[/TD]

[TD="class: xl68"] #5 [/TD]
[TD="class: xl63"]1.1[/TD]
[TD="class: xl63"]3.2[/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"]1.6[/TD]
[TD="class: xl69"] [/TD]
[TD="class: xl63"]1.1[/TD]
[TD="class: xl63"]
[/TD]
[TD="class: xl63"]2.0
[/TD]
[TD="class: xl63"]3.9
[/TD]

</tbody>

 

[Ultimate Selector]

This seems to be kicking my butt. I have researched this for the last 2 hours and can't find a solution.
Hellllpppp!

 

[Mazbuka]

What about using MAX...=MAX(B2:B10)>3...this will look at the largest number in the range and return TRUE if it exceeds 3, then work this into your conditional formatting?

 

[Ultimate Selector]

What about using MAX...=MAX(B2:B10)>3...this will look at the largest number in the range and return TRUE if it exceeds 3, then work this into your conditional formatting?

Thank You soooo much Maz! I got it to do exactly what I needed it to do,Thanks to your help!

I was over thinkin it.

Much Appreciated and Merry Christmas my Friend!