It seems if there is conditional formatting, then cell validation won't work, and vise versa.
Attached is my simple program. I can get either validation to work or conditional formatting to work, but not both. When I have both on, the program will run, but the generated excel file is messed up and won't open. If I repair and open, I get nothing.