software

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

quot;Montyquot; gt; wrote in message
...
gt; Is there anyway i can set up a condition or formula to change the color of
gt; 8
gt; cells within a row if one of these cells have the word Holiday.
gt; I can get the cell that holds the text of Holiday to change but have had
gt; no
gt; joy with the others.
gt;
gt; Thanks
gt;
gt; 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=quot;Holidayquot;)

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