VBA - Determine if Cells Contain a Specific Value in Excel

Excel Function: COUNTIF()

Code with the IF statement included:

=IF(COUNTIF(A1,"*Yellow*")>0,"Value Found", "Value Not Found")

Code without the IF statement:

= COUNTIF(A1,"*Yellow*")

Find if a Value is in a Range of Cells

= COUNTIF(A1:A5,"*Yellow*")