Hello experts!
I have a long worksheet with lines of "text" going down column C (C200 down to C1300)
What I would like to do is have any lines of text in the color "Red", "copy down" into another section
in the worksheet. (in column CC1320 down to CC1360)

Can this be done with a formula?
(Excel 2003)
(the amount of text lines in red may vary from just a few lines to maybe 40 lines)

Thanks in advance for any help!