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

 

[Joe4]

What exactly are you trying to do?
Are you trying to search the range A1:B2, and highlight the cell that is equal to the value in cell A5?
If so, just use this Conditional Formatting formula:

=$A$5

 

[arthurz11]

What exactly are you trying to do?
Are you trying to search the range A1:B2, and highlight the cell that is equal to the value in cell A5?
If so, just use this Conditional Formatting formula:

=$A$5

I have done that but to no success. It highlights all the cell's within that range. It should highlight just cell A1. Even if I select any number in cell A5, it still highlights all the cell's in that range.

 

[Joe4]

I have done that but to no success. It highlights all the cell's within that range. It should highlight just cell A1. Even if I select any number in cell A5, it still highlights all the cell's in that range.

Whoops, the formula should look like this:

=A1=$A$5

The "A1" represents the very first cell in the range you have selected to apply the Conditional Formatting to.
Excel is smart enough to adjust it for the other cells in the range.

 

[arthurz11]

What exactly are you trying to do?
Are you trying to search the range A1:B2, and highlight the cell that is equal to the value in cell A5?
If so, just use this Conditional Formatting formula:

=$A$5

When I use it without the $ signs in the Conditional Formula, it does highlight cell A1. But when I change B2 to a 1. It doesn't highlight it.

 

[Joe4]

Did you change the formula to what I showed in my last post?
And you ABSOLUTELY need to keep those dollar signs in the formula in order for it to work correctly.

Examples of it working:

 

[arthurz11]

Did you change the formula to what I showed in my last post?
And you ABSOLUTELY need to keep those dollar signs in the formula in order for it to work correctly.

Examples of it working:

View attachment 116520

View attachment 116519

Did you change the formula to what I showed in my last post?
And you ABSOLUTELY need to keep those dollar signs in the formula in order for it to work correctly.

Examples of it working:

View attachment 116520

View attachment 116519

Now that it works, will I be able to search from range to range? For instance, in the Conditional Formula write = A1= $A$5:$B$6,$A$1:$B:$2. Or do I have to put another post if this formula does not work? I am going to try it now.

 

[arthurz11]

Now that it works, will I be able to search from range to range? For instance, in the Conditional Formula write = A1= $A$5:$B$6,$A$1:$B:$2. Or do I have to put another post if this formula does not work? I am going to try it now.

Nope, it didn't work

 

[Joe4]

 = A1= $A$5:$B$6,$A$1:$B:$2

That is not a valid formula. I literally have no idea what you are trying to do here.

Can you show us an actual example of exactly what you are trying to do (show us your data and your expected result)?

 

[Joe4]

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