Copying Conditional Formatting

F

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)
 
S

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top