Hi,

You can use conditional formatting.

Select the row then
Format|Conditional format - Formula is - and enter the formula

=$A1="Yes"

Pick a colour
click Add and repeat the above but this time use the formula

=$A1="No"
and pick a different colour

Mike

"Honorbar" wrote:

I want to create a rule that when there is a "yes" answer in a column, that
whole row will remain black in color but when there is a "no" answer in a
column, that whole row will turn grey in color. I know it has got to be a
"If Then" rule but I don't know how to write it. Does anyone have any
tips/guidance on what the rule would look like? Thanks!