Conditional format top and bottom 2 values in each row

[lukela85]

Hi all,

I have a worksheet with around 1300 rows. I have a conditional format set on the first row to highlight the top 2 and bottom 2 values in cells B2:S2. I would like to be able to copy the conditional format for all rows in the worksheet. So in the next row down highlight top and bottom 2 in cells B3:S3 and so on. Is this possible?

Thanks,

Luke