Cond. Formatting Trouble

  • Thread starter Thread starter Matt
  • Start date Start date
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?
 
I'd check the calc mode first. Ensure that it's set to auto.
(Click Tools > Options > Calculation tab. Options are there)
 
Back
Top