Change cell colour of row based upon text contained in a cell

Hi Ryan, you don't need to do this with code you can do it simply with conditional formatting.

Select all your data excluding the headings

Click Conditional Formatting on the Home tab

Choose New Rule from the drop down

Choose "Use a formula to determine which cells to format"

In the field below enter:

=IF(ISNUMBER(SEARCH("*move to*",$I1)),TRUE, FALSE)

...altering $I1 to be the first cell in the field you are testing, keeping the absolute reference on the column

Click format and apply any formatting you want

Click OK and check if your conditional formatting has been applied

If it hasn't, it's probably due to a Microsoft bug. Go back to the Conditional formatting drop down and choose Manage Rules. Click on your rule and then on Edit Rule. See if the cell reference has been altered to something like $I1048576. change this back to $I1 and reapply. That should do the trick.

Hope this helps,

Anthony