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

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
 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:
 4
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.
 5
Thanks
0
Steve_Brady
Asked:
Steve_Brady
2 Solutions
 
themrrobertCommented:
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
0
 
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
0
 
Steve_BradyAuthor Commented:
2 replies
0
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

Cloud Class® Course: Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

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