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.