Search Value and highlight Row-CodePudding

I am using conditional formatting to search a value in a cell and apply it to a specific column. If the data matches it highlights the entire row. The issue I am having is that if I search the value of "20" and that number is a part of a value in the search range such as "120" it highlights the "120" row also. Is there a way to only highlight the rows that contain values of "20" and not highlight partial matches?

Here is the formula I am using.

=SEARCH($C$6,$C10)

Best,

CodePudding user response：

here's how it's done:

=$A1=20

=$A1=$D$1

if that won't work you have a formatting issue. in that case use:

=$A1*1=$D$1*1

CodePudding user response：

Thank you everyone for your help. There was a formatting issue in the main sheet, so I re-made the sheet and used this formula in the conditional formatting.

=SEARCH($B$6,$C10)

Now everything seems to work as intended.

Thank you again,