Move colored formatted cells to another worksheet

M

Maddoktor

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
 
B

Bob Phillips

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)
 
Top