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) Format
6) Fill tab
7) Choose a colour
8) OK
9) OK
