Conditional Formatting Not Working

Question

Can anyone explain what is going on here, and more importantly, how to fix it?

My Conditional Formatting quit working and when I try to create a condition, the font & size are greyed out and when I save the condition, it just doesn't do anything. Everything worked fine a few days ago, but now it's not working. Notice the message about being a cloud font. I can't select a font, and nothing had downloaded in a couple of days, so how do I fix this?

Answer 1

Hello Jack12345JH,

I'm Ibhadighi and I'd happily help you with your question. In this forum, we are Microsoft consumers just like yourself.

The image you've uploaded indicates that you're dealing with a cloud font in Excel, which seems to be affecting the functionality of Conditional Formatting. Here's a simple solution to try and fix the issue:

1. Select a standard font that is not a cloud font. Cloud fonts may need to be downloaded before they can be used, and this could be causing the issue with Conditional Formatting. Choose a font like Arial or Times New Roman that is readily available on your system.
2. Ensure that your internet connection is active and that there are no issues with Microsoft Office connecting to the internet to download cloud fonts.
3. Make sure your Office suite is updated. An outdated version may have bugs that prevent Conditional Formatting from working correctly.
4. Close Excel and reopen it, which can often resolve temporary glitches.
5. Remove all Conditional Formatting from the affected cells and then reapply it using a standard font.
6. If the problem persists, you might want to try repairing your Office installation. Go to **Control Panel > Programs > Programs and Features**, find Microsoft Office in the list, select it, and click on "Change" at the top. Then choose "Quick Repair" or "Online Repair."

I hope this helps.

Best Regards, Ibhadighi