Problem with excel 2003

Hello,

I have a problem with excel 2003
I am trying to do this:

i have a sheet with 20.000 rows and some of them (the rows with the died persons) are with red text color
So i need to find all the red text rows and i am trying to do it so by an if.... then.... mackro

if (row text line is red ) then ( put value 1 in a cell (A1 :A20.000)on every row)

THE PURPOSE is that after the makcro to find rows with red text color and cut them so as to paste them in a new sheet

I would be gratefull if you could just help me


(i don want to use VB but an if mackro)


Thanks in advanced
Nick