Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a set of data in sheet 1 and I need to transfer to sheet 2. I have
used VLOOKUP to transfer 10 selected rows of data from sheet 1 which displays in sheet 2, APART from coloured cells. These cells contain no formula's, they are just shaded, but VLOOKUP does not transfer this colour (it just displays 0). Is there a way to get the coloured cells to show in sheet 2? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
sum coloured cells | Excel Discussion (Misc queries) | |||
Grouping like coloured cells | New Users to Excel | |||
coloured fonts in cells | Excel Worksheet Functions | |||
count coloured cells | Excel Worksheet Functions | |||
Coloured Cells | Excel Discussion (Misc queries) |