Hi:

I have data in cells A5:d5 and I want to conditional format it should a value in cell l5 equal a particular value. Obviously this is easy. I need the same conditional formatting for the next 999 rows underneath it. My problem is that if I copy A5:d5 and highlight all the rows I want the conditional formatting and paste special-formats. the conditional formatting becomes "a5:d1000" Is there a way other than individuallu copying and pasting each row?

Thanks,