hey there 

im kinda stuck and would love if anyone can pull me out of the mess im in 

made a table with checkboxes in it 

they are all on column J they drop true or false on column Z 

if pressed the entire line is painted red untill unclick 

my table starts from line 5 so i added a rule “=$Z$5=TRUE” and for the paint of the line i placed “=$A$5:$K$5”

it works well for that line but i need it to work on all 1995 lines after

i did try everything , recording , special paste they all do 2 things wrong 

1)they refer to the cell they been taken from so when i copy it to lets say cell J6 from 5 i still get =$Z$5=TRUE

2)the painging of the line is all wrong (wrong place for the first problem and also wrong size )

insted of color on all the cells A to K on that line its only paint the true /false cell on cell Z

i hope there is an automated way to do it without manualy rule each 

​hey there im kinda stuck and would love if anyone can pull me out of the mess im in made a table with checkboxes in it they are all on column J they drop true or false on column Z if pressed the entire line is painted red untill unclick my table starts from line 5 so i added a rule “=$Z$5=TRUE” and for the paint of the line i placed “=$A$5:$K$5″it works well for that line but i need it to work on all 1995 lines after i did try everything , recording , special paste they all do 2 things wrong  1)they refer to the cell they been taken from so when i copy it to lets say cell J6 from 5 i still get =$Z$5=TRUE 2)the painging of the line is all wrong (wrong place for the first problem and also wrong size )insted of color on all the cells A to K on that line its only paint the true /false cell on cell Z i hope there is an automated way to do it without manualy rule each   Read More

​