Conditional Formatting Stopped Updating

americantuna

New Member
Joined
May 8, 2019
Messages
11
Hello all,

I am having an issue with conditional formatting not updating in my cells. It was working this morning and at some point stopped. However, if I save the file, close it, then reopen it, updates show up just fine. But, if I do that and start working in it again, the cells don't update until I close it out and reopen.

I haven't added any columns or rows to my table, so it shouldn't be breaking any chains.

I've cleared out my formatting and reentered all of them. I also tried restarting the computer. Both with no luck.

Anyone know if this is just a bug that will clear up, or is there an option I need to check for?
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,821
Office Version
365
Platform
Windows
Do you have calculation mode set to Manual?
If you click F9, does it update?
 

americantuna

New Member
Joined
May 8, 2019
Messages
11
Do you have calculation mode set to Manual?
If you click F9, does it update?
I don't know how to tell if it's set to Manual or not.

It does not update if I use F9. I still have to close the workbook and reopen it to get it to be correct.
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,821
Office Version
365
Platform
Windows
I am talking about the pressing the "F9" key on your keyboard, not typing in F9.
That is the calculation key. If your calculation mode was set to manual, pressing F9 forces a calculation.

In order for us to analyze, I think we need to know exactly what your Conditional Formatting formulas are, and what your data looks like.
 

americantuna

New Member
Joined
May 8, 2019
Messages
11
I am talking about the pressing the "F9" key on your keyboard, not typing in F9.
That is the calculation key. If your calculation mode was set to manual, pressing F9 forces a calculation.

In order for us to analyze, I think we need to know exactly what your Conditional Formatting formulas are, and what your data looks like.
No, I understood the F9 key.

When I push F9, it does indeed work.
 

americantuna

New Member
Joined
May 8, 2019
Messages
11
So I did some digging around and found that the Calculation Options was indeed set to Manual. I didn't know this button existed in the Formulas tab.

I've switched it back to Auto and it works fine now.

Thank you for leading me in that direction. I appreciate it.
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
51,821
Office Version
365
Platform
Windows
You are welcome.
 

Forum statistics

Threads
1,085,960
Messages
5,386,948
Members
402,026
Latest member
rudyd06

Some videos you may like

This Week's Hot Topics

Top