Move colored formatted cells to another worksheet

  • Thread starter Thread starter Maddoktor
  • Start date Start date
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
 
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)
 
Back
Top