conditional formatting entire row if cell contains text

excel excel-2010 row conditional-formatting
Amandip Singh picture Amandip Singh · Aug 10, 2016 · Viewed 8k times · Source

I have an excel sheet where I'm trying to use conditional formatting but it doesn't seem to work as I would like it to.

It seems as though any formula won't work as I don't want the cell to match TBC, but contain it.

In short, I am looking for this:

If D2 Contains "TBC" then highlight the whole row

I've tried around 10 suggestions through Google and also Stack Overflow but it seems as thou

Note: Each cell will have different values, i.e. D2 has "1 screenshot TBC" and D3 has "5 screenshots TBC". As they will all have different values but all contain the abbreviation "TBC" I am trying to search for that word.

Any help or advice that could be offered will be greatly appreciated.

Thank you in advance for your time! :)

Amandip

Answer

pnuts picture pnuts · Aug 10, 2016

Select your entire sheet and HOME > Styles - Conditional Formatting, New Rule..., Use a formula to determine which cells to format and Format values where this formula is true::

=FIND("TBC",$D1)

Format..., select colour Fill (highlight) of your choice, OK, OK.

Change FIND to SEARCH if you want this case insensitive.

This will trigger for the likes of ATBCX.

Related questions

IF statement: how to leave cell blank if condition is false ("" does not work)

I would like to write an IF statement, where the cell is left blank if the condition is FALSE. Note that, if the following formula is entered in C1 (for which the condition is false) for example: =IF(A1=1,B1,"") …

Read More
Remove leading or trailing spaces in an entire column of data

How do I remove leading or trailing spaces of all cells in an entire column? The worksheet's conventional Find and Replace (aka Ctrl+H) dialog is not solving the problem.

Read More
Insert picture into Excel cell

I'm tying to generate a report with pictures, but I cannot get the pictures into a single cell. I can get the pictures to "float" around my worksheet, but I need to put them into a cell. How can I …

Read More