Excel – Formula to check if cell contains specific string

=ISNUMBER(SEARCH(substring,text)) If you need to check if a cell contains a substring (specific text), you can do so with the Read More …

Change the row color based on a cell’s value (Excel)

Say, you have a table of your company orders like this: You may want to shade the rows in different Read More …