Highlight Row range if checkbox is True

[bobby786]

Dear All Expert ,
I have worksheet in which Each row has its own checkbox, referencing to a unique cell link

For Eg
A6=checkbox , Linked to DT6 , B6 to Display Text based on DT6 true or false. with the help of formula

=IF(DT6 = TRUE, "Done", "Open")

The following condition is required: When a user ticks the checkbox, the corresponding cell range defined in conditional formatting should be highlighted (say uniformly green). The user can tick as many checkboxes as he likes, highlighting all the cells that the checkbox(es) is/are controlling.

I was able to create this for one row , but there is hundreds more , and applying manually conditional formatting to all is very tedious work , i believe there will be more decent way to do it ,

my question is
1. how can i clone the conditional formatting formula to rest of the linked cell which ?

 

[mart37]

=$DT6

 

[bobby786]

=$DT6

it worked , but i ran into other problems , because my sheet data is linked to other sheet in same workbook , when i copy and paste special format only , the other sheet data all get messed up , luckily i have backup of original file , otherwise i would have to enter 100's of rows data again .

 

[mart37]

You don't have to copy CF.
You can use the dialog window to apply the rule to a range:

 

[bobby786]

i am able to create for one row ,but there is 100's of row which need the same treatment.
you mean to say i have to do this same steps for each row one by one, there is no way to automate it ?

Regards

 

[mart37]

For 500 rows:
Formula: $DT6
Applies to: $B$6:$AY$506

 

[bobby786]

For 500 rows:
Formula: $DT6
Applies to: $B$6:$AY$506

with that formula it is highligting all 500 rows for one click , where as i just want to highlight the row which is True by checkbox command

 

[mart37]

Your formula is different.
Formula: $DT6

 

[bobby786]

Your formula is different.
Formula: $DT6

Ah my bad ,
it worked , thank you mate.