Im using conditional formatting and data validation to allow a user to select "yes" or "no" and when YES the cell is colored green and when NO the cell turns red. the cells are defaulted to NO[RED] and switch to YES[Green] just fine, however when going back to NO[RED] the cell just becomes blank.

what do?