Format row based on single cell contents (Excel 2002/SP2)

[JoeCool]

Does anyone know of a way to format an entire row based on the contents of one cell?

For example, if A1 contains "yes", make the background color of all cells in row 1 yellow.

Thanks

[LegareColeman]

Try the following:

1- Select the row to be formatted.

2- Select "Conditional Formatting ..." from the Format menu.

3- In the drop down list on the left select "Formula is".

4- Enter this formula in the formula text box:

<pre>=UPPER($A$1)="YES"
</pre>


5- Click on the Format button.

6- Click on the Paterns tab.

7- Click on the color you want for the background color.

8- Click on OK to close all dialor boxes.