Forum Discussion
Conditional Formating with formular based on check box form control
My column G has check box form control. I need to set conditional formatting for column D so that when the check box is marked checked, the column D is formatted
Thanks.
If we have over a hundrend rows, is there a way to auto replicate the formula across rows
If we have over a hundrend rows, is there a way to auto replicate the formula across rows
Run this macro:
Sub AssignCellLinks()
Dim chk As CheckBox
For Each chk In ActiveSheet.CheckBoxes
chk.LinkedCell = chk.TopLeftCell.Address
Next chk
End Sub