I'm thinking you want conditional formatting of sorts. What exactly do you
change on the sheet and what do you want to do with the colors?

1) Do you want a specific color if the value is within certain ranges

Read more about this here
http://www.cpearson.com/excel/cformatting.htm

2) Do you want a color if the cell has been changed at all (one value to
another)

You may need to use a worksheet change event. Please come back if you need
more assistance with this.
--
HTH,
Barb Reinhardt



"shiro" wrote:

How to automatically change the cell's bakground colour
if it's value is updated?