Cond. Formatting Trouble

M

Matt

I have a spreadsheet with cells that have conditional formatting to
turn a certain color based on the input value. Its been working fine,
until the last few times it has not changed the color of the cell
until I close and reopen the sheet. Why might this be?
 
M

Max

I'd check the calc mode first. Ensure that it's set to auto.
(Click Tools > Options > Calculation tab. Options are there)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically change the text format the cell when use a specific text 10
Excel Macro to automatically go to the right of the last colored cell 0
Excel VBA 1
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
If B1 is not empty but B2 is ... conditional formatting "formula"? 2
Count of Font Format 1
#VALUE! problem; not enough cond formatting slots to fix. 4
Conditional formatting in Excel_Strange behaviour 6

Top