Thread: Can a cell reference bring the color of the data to the new sheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Can a cell reference bring the color of the data to the new sheet
Cell formats cannot be linked or returned by formula.

Can you use Conditional Formatting to achieve your needs?


Gord Dibben MS Excel MVP

On Mon, 10 Jul 2006 16:18:02 -0700, SandyA
wrote:

I'm creating a summary page with about 100 back sheets that have some data in
colors that should show up in the summary page. Is it possible to copy the
colors when cell referencing on the summary page?

Reply With QuoteReply With Quote