Forum Discussion
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
- Riny_van_EekelenPlatinum Contributor
arie690 Use the following CF formula:
=$Z5
Important that you don't have the $ sign before the row number and no need to add '=TRUE'
Attached an example file.
- arie690Copper Contributorthank you Riny u saved me hours of work ❤️
worked perfectly