Hello,

I have an issue with conditional formatting in which it seems as if the cells I have applied the formula to are not applying the rule. For example, I have it set that if the choice in the drop down box for cell D11 is a "no", cells D15 thru D24 should be filled black so that the user knows he/she should not input data. However, when I apply this rule, only some of the cells turn black upon the "no" being chosen. When I scroll down and modify some of the answers in cells D15 thru D24 (which are yes/no and automatically default to "no"), other cells in the same range randomly fill black. Any ideas what's going on here? I've tried to re-do this many times, but I'm not quite sure why this is happening.

Thanks in advance