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.

	#1	#2		#4	#5	#6	#7	#8	#9
#1		2.1		1.6	0.9	1.0		1.9	3.5
#2	0.5			0.7	0.3	0.5		0.8	2.0
#4	0.6	1.4			0.6	0.6		1.2	2.1
#5	1.1	3.2		1.6		1.1		2.0	3.9

<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>
</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!