Many spreadsheet software have a feature called conditional formatting that allows you to apply custom formatting to cells that fulfil certain conditions. It's most commonly used to highlight, emphasise, or separate facts and information in a spreadsheet using color-based formatting.
Select the cells to which conditional formatting should be applied. Drag from the first cell in the range to the last cell in the range.
Select HOME > Conditional Formatting > Highlight Cells Rules > Text that Contains from the drop-down menu.
Click OK after selecting the text's colour format.
Share a personalized message with your friends.