Move colored formatted cells to another worksheet

Hi all,

I would like to know if it is at all possible to run a macro via a button of
as soon as a cell's text is formatted a certain color that the cell's text
and complete row is moved to another worksheet?

Thanx in advance

There is no event to trap that tells you text is coloured, so it cannot be
event driven. You could have an after-the-event macro that is manually
fired.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Maddoktor" <[email protected]> wrote in message
news:[email protected]...
> Hi all,
>
> I would like to know if it is at all possible to run a macro via a button
of
> as soon as a cell's text is formatted a certain color that the cell's text
> and complete row is moved to another worksheet?
>
> Thanx in advance
>
>