• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 915
  • Last Modified:

Unable to change font color in Excel Conditional Formatting


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
 1which is then changed to green
 2but note here,
 3that 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.
2 Solutions
Its most likely a glitch in excel 07, they redid all the cf back code. you will have to delete the rule and add a new one with the new color
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello Steve,

what color is applied to the cell when you close the dialog and change the cell value of I234 to "j"? Green or Purple? If the correct CF is applied, it may just be a rendering issue with XL 2007. It does have a reputation for being buggy.

What happens if you save and close the file, then re-open? Is the preview still purple then?

cheers, teylyn
Steve_BradyAuthor Commented:
2 replies
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now