how to automatically change cell colours when certain data changes

B

bsroofing

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to change lines in graph to individual colours 0
Changing the backcolor of a cell when data is added 1
Remove colour change 4
How do I stop the font from changing colour automatically? 1
cell colours to change according to totals 1
Don't change cell colours when adding or deleting rows? 1
change cell colour due to a specific data set 1
get cell to automatically change colour depending on text in adja. 1

Top