I need to set-up three formali in each row of a 1000 row spreadsheet. The
three forumli a

=A4="x" then B4 : P4 strickthrough, green font
=B4<Today() B4:P4 Font Red
=R4=True B4:P4 Font Purple Italic.

I enter that in Row 4 , now I need to repeat this for every row, but every
attempt fails to change the row identifier- thus every row ends up refering
to row 4 only. Hope do I copy this instead hand writing each row- 1000 rows?