Sleeper: More Form help needed

[austenr]

Nothing highlights. I am fine with the previous version, I can work around the conditional formatting issue. There are some things I don't understand. All the cells are not highlighted that should be but the weird thing is is that they are defined at the top of the program. I am attaching the zip file so as not to get confused.

Thanks for all your hard work and help.

[Zack Barresse]

They aren't highlighted because there is problems when referring to a single cell in a set range when that cell is Merged. That is why I have unmerged all of your cells in my last post and gone with only the Conditional Formatting to highlight/unhighlight cells which require data input. Did you look at the second file I uploaded? There were two, I deleted the first one. The second one is all that remains as I didn't want to confuse anyone.