How can I search inside a range by using the Conditional Formatting to search a value by using the cell's letter and number instead of a value?

[arthurz11]

For example: Range is A1:B2.
Cell A1 is 1
Cell A2 is 2
Cell B1 is 3
Cell B2 is 4

Cell A5 is 1

After highlighting range A1:B2. Select Conditional Formatting and use the formula =SEARCH( A5,1,0)) and format the color cell A1 yellow? That way it will search any cell within the range that contains the value 1 and highlighted yellow. Even if more than one cell contains the value of one.
I did not use the IF statement because the value of Cell A5 will always change

 

[arthurz11]

OK, I missed that my answer did solve your first question, and now you are actually asking a new, different question.

I posted a new one you got the answer correctly. Thank you so much for your time.