Here's another...conditional formatting has been "glitching" around a
lot, as well. Have you noticed anything weird with this? I have
tried the conditional formatting provided in the program and created
it on my own with the cell.

For example:
=if("D4="Years",E4/F4,text(E4/F4,"0.0%"))

This formula works most of the time, but just stops working in some
instances until you edit the formula, altering nothing, and
recalculate. Same with the conditional formatting functionality built
into excel. (Note: I have already verified uniform formatting of
the
source date.)