View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rich Young
 
Posts: n/a
Default Function for copying color formatting

I am attempting to copy the color formatting from one cell to another on a
different worksheet. I do not see a function for it so I was wondering if
there was some VBA code to do it.

Here is an example of what I am trying to do:

Worksheet A has A1 formatted with red, A2 formatted with yellow, and A3
formatted with green. All which are conditionally formatted.

On worksheet B, I want to reference A1 (or any cell) from worksheet A which
would include the contents and color.

Any help is appreciated!

Rich