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
|