I am trying to grey out an entire row in excel 2010 depending on a cell's value.
Each cell has a drop down list: Yes, No, Maybe etc
I want the entire row going forward, to only be greyed out if a cell indicates the value No. and the row remains active if other options are selected.
I look forward to hearing your thoug...