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

"Monty" wrote in message
...
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

Let's suppose the cell that will contain the text is A1.
Select the 8 cells. Apply conditional formatting using the formula:
=($A$1="Holiday")

If subsequently needed, you can use the format painter to copy the
formatting from one of these cells to any other.
The key point is to use absolute addressing ($A$1), so that the formula
always refers to the same cell rather than adjusting for each individually.

Stephen