Is there anyway i can set up a condition or formula to change the color of 8
cells within a row if one of these cells have the word Holiday.
I can get the cell that holds the text of Holiday to change but have had no
joy with the others.

Thanks

Monty