I'm crap as far as excel goes, so don't confuse me with an expert.
Maybe you could creat a macro for the conditional formating of 365
cells. Just a thought.