Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default Coloured Cells

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sum coloured cells Manxie Excel Discussion (Misc queries) 1 June 25th 07 12:52 PM
Grouping like coloured cells [email protected] New Users to Excel 1 March 6th 07 05:02 PM
coloured fonts in cells tom Excel Worksheet Functions 0 January 19th 07 08:24 PM
count coloured cells ile Excel Worksheet Functions 4 June 19th 06 08:38 AM
Coloured Cells Becks Excel Discussion (Misc queries) 3 February 8th 06 12:46 PM


All times are GMT +1. The time now is 03:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"