I really don't know what is wrong with my Excel. It was killing me silently. Luckily someone introduced me to the conditional formatting, which does exactly what i need done. Insanity narrowly averted.