Bob,
So why is it that the below doesn't work (Get R/T 424 - Object required)?
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Activcell.Interior.ColorIndex = 6
End Sub
Thanks,
Jim
"Bob Phillips" wrote in message
...
So if you know the colorindex, it is simply
Activcell.Interior.Colorindex = nColorIndex
where nColorIndex is that extarcted colour.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Dana Zulager" wrote in message
...
actually, using Pearson's VBA functions [ColorofCF, ColorIndexofCF] i
can
in
one function extract the color or color index of the
conditionally-formatted
cells (i am only applying a color, nothing else) ... so all i need to
know
now is how to "apply" that color code to another cell ... ???
that's all i want to do is grab the conditionally-formatted color (if
there
is one) and apply it to a cell with no conditional format applied.
... dana
"Bob Phillips" wrote:
Dana,
This can be done, but it would mean examining each condition and
testing
if
the cell meets that condition and extracting all formatting. A lot of
effort, do you want to go through that?
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Dana Zulager" wrote in
message
...
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.
|