I am not sure of what you are trying to do.. It is always better to upload sample workbook to illustrate your issue well
As for dealing with whole column you could replace this line
If Target.Address = "$C$2" Then
With this line
If Not Intersect(Target, Columns(3)) Is Nothing Then
This will allow you to deal with any cell in column C not only C2
Hope this will help you