Copying Conditional Formatting

[Fireguy88]

I have 4 CF's set on range B6:J6. The range fill color will change based on
the value of cell D6. If D6=1 then the fill color is red, D6=2 yellow and
D6=3 green. the fourth CF is on cell J6. If J6=1 then the range is gray. this
CF overrides the other 3 based on its position in the CF rule manager. It
works great for this row.

I need to apply the same CF's to 300 more rows below that one. Is there a
way to copy CF's to the other rows while maintaining that row's reference to
the D column? (so that row 8 is looking at D8 and not D6)

 

[Sean Timmons]

Merely remove the $ before the row number in your CF's.

So $D6 instead of $D$6

Then, copy and paste special/formats down your rows.