conditional formatting - to hilite a row
 

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.

conditional formatting - to hilite a row
 

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

conditional formatting - to hilite a row
 

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