how to automatically change cell colours when certain data changes
 

In excel 2007, I have multiple columns of data. When I change the colour of
any one cell, I would like any other cell with matching data to also
automatically change to the same colour. Does any body have any suggestions
on how I could achieve this?

how to automatically change cell colours when certain data changes
 

Use conditional formatting.

See
http://www.accountingweb.co.uk/cgi-b...&h=1033&f=1026

"bsroofing" wrote:

In excel 2007, I have multiple columns of data. When I change the colour of
any one cell, I would like any other cell with matching data to also
automatically change to the same colour. Does any body have any suggestions
on how I could achieve this?