Have Excel tell you if there is an uncalculated formuila

[excelboss1]

I know it does this in the status bar, but this is kind of hard to see. I have calculations set to manual. So i would like to have a conditional format of some sort that make it very noticeable that formulas are un calcualted and need to be calculated to be accurate

 

[mole999]

if you turn the calculation back on in the vba that should solve the pproblem

 

[excelboss1]

That doesn't really help. The point is to keep calculatiosn off so they can be done all at once when all the inputs are entered. I am just afraid people using the file will forget to update the calculations

 

[Rick Rothstein]

I have calculations set to manual.

How do calculation get set to manual... via a macro or does the user flip the option on their own using the Ribbon? Same question for turning calculations back on.

 

[excelboss1]

I set calculations to manual. I have a button macro that has excel calculation. I want to make sure people dont forget to hit that button after updating inputs