The way the conditional formatting rules are currently written:


1. You can create condtions that are X or Y when X and Y are values that have already been filled in by click on both from the menu.  

2. You can create chains of "and" statements based on various condtions such as "is blank" or