I am creating a Macro to do the following..
Comapring two cells containing date values.
If Date1 - Date 2 > 7 days, copy a GREEN coloured circle object from other cell and paste it in another cell.
If "Date1 - Date2 < 7 days ", copy a RED coloured object from other cell and paste it into another cell.
I have created a macro using IF statement but it is working only the first time. But If I change the Date values, macro is not recognizing the change, again pasting the previous colour.
Please help me..
Thanks in advance
Comapring two cells containing date values.
If Date1 - Date 2 > 7 days, copy a GREEN coloured circle object from other cell and paste it in another cell.
If "Date1 - Date2 < 7 days ", copy a RED coloured object from other cell and paste it into another cell.
I have created a macro using IF statement but it is working only the first time. But If I change the Date values, macro is not recognizing the change, again pasting the previous colour.
Please help me..
Thanks in advance