In Excel (2007), what would cause the font color assigned in Conditional Formatting (CF) to be unchangeable.
For example, this figure shows a purple font as the existing CF
which is then changed to green
but note here,
that although green is displayed in the Font Color box, purple persists in the Preview box, as it does when back to the CF Rules Manager:
What might cause that issue and how can it be corrected?
Incidentally, opening a brand-new "clean" workbook shows that the green formatting works just fine.