| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell colours to change according to totals | Excel Discussion (Misc queries) | |||
| Really basic question! Cell colours change when emailed. | Excel Discussion (Misc queries) | |||
| is there a formula to auto change cell colours | Excel Discussion (Misc queries) | |||
| Excel will not change cell border colours | Excel Discussion (Misc queries) | |||
| automatically change cell colours | Excel Discussion (Misc queries) | |||
Linear Mode
