Conditional formatting produces a color based on the condition in the
formula. So if you want the color, you need to reproduce the conditions
that produce it. If your formula is absolute, it should evaluate to the
same condition as A5. If not, then it won't - it will look relative to its
current location.

--
Regards,
Tom Ogilvy




steveh wrote in message
...
Im using the following macro

Sub AddColumnt()
ActiveCell.Offset(0, 1).EntireColumn.Insert
Range("A1:A10").Copy ActiveCell.Offset(0, 1)
End Sub
It copies A1:A10 and inserts column and paste next to active cell.

Cell A5 has a formula as well as conditional formatting using isformula
UDF. The cell is colored yellow and if there is a formula it is white, so
at the time of copy it is white. (Im' trying to see that user has over tpyed
foormula). The copy picks up the CF but it doesnt pick up the cell color.
Seems as though I can get the formula and the CF but not the cell color.
What can I add to pick up that color as well as the CF.

Many Thanks
Steve