Checkbox if checked change color of multiple adjacent cells

JKPieterse they are linked to cells.  My question is whether or not there is a more efficient way to link the cells.  For each checkbox I linked the appropriate cells in order to apply a fill color the specified cells for each and every row.  It took me forever.  I'm looking for a way to select several rows and apply the formatting without having to do each one.... Or to duplicate the formula over and over again accurately.  Currently if you copy and paste the formatting it does not recognize that it's a different row and it copies it verbatim.  After doing this and checking the check box it fills in the cells in every row I pasted the formatting into.