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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Matt" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>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?
>