If a range contains a value greater than

Specific Value:
Range:
Value if range contains greater than a specific value:
if the value that you want returned is a text value, you will need to include the quotation marks around the value. However, if you want to return a numeric value or referencing to a cell then there is no need to include the quotation marks.
Value if range does not contain greater than a specific value:
if the value that you want returned is a text value, you will need to include the quotation marks around the value. However, if you want to return a numeric value or referencing to a cell then there is no need to include the quotation marks.
Formula:

=IF(COUNTIF(C8:C14,">"&C5)>0,"Yes","No")
=IF(COUNTIF(C8:C14,">"&C5)>0,"Yes","No")