Hi,
I want to hilite a row if A1="Yes" on my worksheet instead of only one cell.
How do I do this?

Thank you.

Avaya,

You will need to apply the same conditional formatting to all the cells
in the row, but you do as follows:

1. Select the Format menu, then Conditional formating.
2. Change "Cell Value is" to "Formula Is"
3. Type =($A1="Yes") in the formula area
4. Select your fomatting
5. OK

You will then need to copy the formatting to the rest of your sheet
(under paste special you can just paste formats)

Steve

Thank you, Steve for your help. It works beautifully.
Avaya

"SIR Knight" wrote:

Avaya,

You will need to apply the same conditional formatting to all the cells
in the row, but you do as follows:

1. Select the Format menu, then Conditional formating.
2. Change "Cell Value is" to "Formula Is"
3. Type =($A1="Yes") in the formula area
4. Select your fomatting
5. OK

You will then need to copy the formatting to the rest of your sheet
(under paste special you can just paste formats)

Steve