Forum Discussion

arie690's avatar
arie690
Copper Contributor
Jul 18, 2024

conditional rule copy

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 

    • arie690's avatar
      arie690
      Copper Contributor
      thank you Riny u saved me hours of work ❤️
      worked perfectly

Resources