ok, good stuff from Pearson (i've been poking around)

knowing next-to-nothing about adding my own functions using VBA, i added the
functions he shows for determining the RGB color components or color code for
a conditional format (www.cpearson.com/excel/CFcolors.htm) ... and i
successfully return the color codes for my conditional formats ...
[ColorIndexofCF(A1,False), ColorofCF(A1,False)]

now how do i apply that color to another cell?? my Excel help functionality
is on-the-fritz, so i'll hunt there and elsewhere.

again, any tips, pointers, etc. are appreciated! ... dana

"Dana Zulager" wrote:

i'd like to figure out how i can copy a group of cells that have a
conditional format (stoplight style ... color pattern highlighted for a
certain condition) and paste special only the format, but not keep the
conditional format rules.

one time that it is necessary is if i have an analysis spreadsheet with all
my rules and formulas and internals, but i produce an "output" spreadsheet
that only shows values, widths and formats. the conditional format for a
particular column depends on the values of a column which i don't even
include in the output sheet, so the conditional formatting rules don't work
as designed once transformed to the "output" sheet.

hopefully this question makes sense! thanks for any tips, pointers, ideas.