Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
changing table cells colours using a master table
master jan feb
1 yellow 2 yellow yellow company 1 jan feb company 2 jan feb 1 ** 1 ** 2 ** ** 2 ** ** I have a set of tables like this. When I colour the master tables cells in yellow I want the other corresponding cells with jan and feb in the row to also turn yellow (**). Is there a way to do this? Please note that the cells with (**) also have data in them which I need to keep. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using 2 cells in a table to retrieve data from another table | Excel Worksheet Functions | |||
VLOOKUP on changing table!!HELP!!lol | Excel Discussion (Misc queries) | |||
create pivot table with master/detail data from 2 worksheets | Excel Worksheet Functions | |||
How to Append the Data to the Master Table | Excel Worksheet Functions | |||
multiple or changing colours in a data table on an excel chart fo. | Charts and Charting in Excel |