Hi,

I want to colour format a range of cells. The critiae for color coding the
cells depends upon a name , ie if a string of text in a cell refers to a
name, colour format the cell for example green. Conditional formatting doesnt
seem to work as the condition is too complex, i think. ie example below if a
string of text in a cell contains either of the names andrea, robert or john
, color the cell green , if a cell contains either of the names bob or jack
color format the cell blue.