Link to home
Start Free TrialLog in
Avatar of Steve_Brady
Steve_BradyFlag for United States of America

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
 User generated imagewhich is then changed to green
 User generated imagebut note here,
 User generated imagethat 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:
 User generated image
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.
 User generated image
Thanks
ASKER CERTIFIED SOLUTION
Avatar of themrrobert
themrrobert
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Ingeborg Hawighorst (Microsoft MVP / EE MVE)
Flag of New Zealand image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Steve_Brady

ASKER

2 replies