Thread: Can a cell reference bring the color of the data to the new sheet
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
SandyA SandyA is offline
external usenet poster
  
Posts: 2
Default Can a cell reference bring the color of the data to the new sh
I don't think that will work because some of the data is text rather than
numeric. Thanks for your help.

"Gord Dibben" wrote:

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