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?