hello is there any way to search a worksheet (sheet 1) for cells whose font
colour is red, and then print the contents in another worksheet (sheet 2)?

eg cell a3 contains 3255 and its font colour is red,
cell a33 contains 444 and its font colour is red.

I would like to output a3 to sheet 2 a1 and a33 to sheet 2 a2.
I would like to write a procedure which looks for these red cells and output
their values.... not in red... to another worksheet

Thank you for your reply