Conditional formatting question

[askexcelq]

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.

 

[dreid1011]

How is the text entered into those rows normally? First thought is to add a format to the CF rule you already have to change the text color to the same gray as the fill color if the text is already in the cell or the result of a formula.