Highlight the range of cells.
Go to the Home tab, click the Conditioning Formatting button in the Styles group, then select New Rule.
A New Formatting Rule dialog box will open.
Select the Rule Type “Use formula to determine which cells to format.”
In the Edit Rule Description box, enter the formula =ISNUMBER(SEARCH ("101", $A3)).
Click the Format button to format the result.
We want the result to have a background. Click the Fill button, choose a color, then click OK.
The result will have a colored background.