conditional formatting - to hilite a row

A

Avaya

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.
 
S

SIR Knight

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
 
Top