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?
|