How to highlight row cell containing partial text - Excel Tips and Tricks

Learn how to highlight row if cell contains partial text. Essentially, highlight row if cell contains text in Excel.
Or highlight row if cell contains partial text. This also works in Google Sheets.

Highlighting a row in a spreadsheet can be a useful way to draw attention to certain data that meets specific criteria. One way to do this is by using conditional formatting to highlight a row if a cell within that row contains partial text. This can be done in a few simple steps, and they are listed below.

Highlight Titles
1) Select table
2) Home -- Style -- Conditional Formatting
3) New Rule...
4) Use a formula to determine which cells to format
5) =AND(ISNUMBER(SEARCH($E$1,$B1)),$E$1"")
6) Format
7) Fill tab
8) Choose a colour
9) OK
10) OK


excel highlight row if cell contains text,highlight row if cell contains partial text google sheets,excel conditional formatting if cell contains multiple specific text,excel conditional formatting if cell contains specific text,conditional formatting excel based on text,conditional formatting if cell contains partial text google sheets,highlight partial text in excel cell,how to highlight cells in excel based on value of another cell