Advanced Excel urgent help

Question

I have conditional formatting rules applied to a workbook. When a user selects No in Row 1 for example, Row 2 and subsequent rows get grayed out. When user selects Yes in Row 1, Row 2 and subsequent rows have cells active. This part is working fine. The problem is when user selects No in Row 1, it also has text also appear as No in grayed Row 2 and subsequent grayed out rows. What conditional formatting can I apply to stop having text appear as No in the grayed out rows? I don't want any text appearing in these grayed out rows.

Answer 1

Here's one quick fix:

Set the font format to the same shade of gray as the "NO" in the cells you indicated. Then the "NO" will disappear into the gray when "NO" is selected.

There are other fixes if that is not acceptable to you.