I'm not a whiz-bang at conditional formatting, and whenever I use it
(which is infrequently) I have to enter the formula, close all the
conditional formatting setup windows, and then re-open them. I usually
find that Excel has added " " quote marks to the formula, which I
subsequently remove to make the conditional formatting work. Could
this be the case for you?