Coping a Coloured cell

  • Thread starter Thread starter The Message
  • Start date Start date
T

The Message

I expect there is any easy answer to this but I am basically wanting to copy
the details of one worksheet into another. Using the basic '= Sheet 1! etc.'
works fine for text, numbers and formulas, but does not seem to work for
simply copying a coloured cell from one sheet to another. The cell has no
formula, number or text. It is simply coloured. All efforts so far have not
worked and all I get is a blank cell (not the coloured one I am looking for).
Any help would be greatly appreciated.
 
Thanks John, but I want this to happen automatically -

eg in worksheet 1, cell B2 is red

I want to type into worksheet 2,

=((cell b2) worksheet 1) and the cell to turn red

Can you help?
 
HI
Sorry, there's no function to copy "Formats", you'll need a macro or possibly a
UDF, but that's beyond my capability.
Regards
John
 
Back
Top