Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting using lookup up in a different sheet
Hello,
I want to do the following: - in sheet 2 a column of cells (could be up to 100) contains unique 4 character text codes, e.g. ABXY, each cell is coloured manually by the user to any background colour they like. - in sheet 1 a range of cells each contain one of the 4 character codes. - I would like to colour the cells in sheet 1 to the same colour as the corresponding cell for the code in sheet 2. I know this is going to require VBA which I'm not familiar with, so I'd be very grateful for your help and suggestions. Thanks, Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter, sort, lookup from other sheet | Excel Discussion (Misc queries) | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional formatting : amount of decimals | Excel Discussion (Misc queries) | |||
Return cell contents based on conditional lookup | Excel Worksheet Functions | |||
Conditional Format using value from another sheet | Excel Worksheet Functions |