Conditional Format?

[SidBord]

When you change the value of the yellow cell, will you
change it to something that is clearly and unambigously
different from the original value. For example, will you
change it from, say, a numeric value to an alpha value, or
from a value between 1 and 10 to a numeric that's greater
than 10, etc.? If you are making such a change, the
conditional formatting will take care of your problem. If
the new value is very much like the original value with no
distinguishing characteristics, then you'll probably have
to write a Visual Basic macro.

-----Original Message-----
I have set up a worksheet that requires me to update any

cells with a background color of yellow. I would like to
have the cell return to a white background once I have
updated the yellow cells. How is this done?

 

[cb]

The value will change. The values will only be of numeric value and will be completely different numbers than what is already in the cell. For example: 10,500 in yellow cell needs to now reflect 100,525 and have a white background. I looked in conditional formatting and did not understand how to use it for this purpose. Thanks!