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!