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 greyed 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 greyed Row 2 and subsequent greyed out rows. What conditional formatting can I apply to stop having text appear as No in the greyed out rows? I don't want any text appearing in these greyed out rows.
1 Answer
If understood correctly, to prevent from appearing in the greyed out rows when No is selected in Row 1, try,
- Use conditional formatting and cell formatting.
- Select the cells in Row 2 and subsequent rows where you don't want the text to appear.
- Go to Conditional Formatting.
- Select "New Rule" from the dropdown menu. In the "New Formatting Rule" dialog box, select "Use a formula to determine which cells to format".
- In the "Format values where this formula is true" field, enter:
=AND($A$1="No",ROW()>1)
- In the Font tab, select the color as white (or the same as the background color) to hide the text.
No
selection is dependent on a previousYes
selection or not. If that's the case you need vba, otherwise add a simple condition to the code forIF(Cell_value ="no",...