Color Shading in the Cell based on Column Percentage Value in a List

Copper Contributor

Dear Colleagues;

I know traditional macro to add date on column when cells has been modified already.

Now, i need to repeat this comand for next columns, "on the same worksheet"

 

For example: Something as ..

If Target.Column = 3 Then
Sheets("FAC").Cells(Target.Row, 13).Value = Now

AND

If Target.Column = 4 Then
Sheets("FAC").Cells(Target.Row, 14).Value = Now

AND

If Target.Column = 5 Then
Sheets("FAC").Cells(Target.Row, 15).Value = Now

AND ELSE...

 

Only works first one.   :( 

 

andres.rojas@sce.com.ec

 

0 Replies