I'm hoping someone can help with this strange issue I'm having. I know how to use conditional formatting, I don't have an issue with that... my problem is that I used to be able to choose the color that I wanted the font to be (format cells) and now every time I choose a color, it just goes right back to "automatic" or black. It used to work just fine, no issues at all then all of a sudden I couldn't do it anymore. Now I have sheets that I need to add to and I cannot match the conditional formatting of my original cells, I can only choose the pre-populated options that are in the drop down menu (if i go to highlight cell rules and choose greater than for instance) such as "light red fill with dark red text", "yellow fill with dark yellow text" and so on... I can't find any kind of setting that would change this, the sheet isn't locked/protected. I'm going crazy, please help!!!!!!!
Bookmarks