Steve_Brady
asked on
Unable to change font color in Excel Conditional Formatting
Hello,
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.
Thanks
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.
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER