In this scenario I wish to format a cell if a different cell contains the text "Extra"


Firstly, select the cell to be formatted


Then, from the Home menu select the Conditional Formatting menu and then select New Rule



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



I want the cell to go green if the word "extra" is found so my formula will beĀ 


=ISNUMBER(SEARCH("extra",A2))


please note - this method is not case sensitive so all instances of the word extra will be picked up even if it is capitalised. Also a positive result will be returned if the word is found within another word (e.g extraordinary would produce a positive result")


The formatting can then be dragged down to fill as many cells as required



Result