Hi,
I have a workbook with two sheets. Each sheet has 5 columns.Columns D and E
change from month to month.
The Column D holds the date mm/dd/yy e.g 11/01/2011.
The Column E hold decimal value which may change every month.
I would like a macro that
1) checks to see if the values have change.
2) Show this change as a percentage. (From column D determine which value in E is the oldest to determine if there was an increase or decrease).
3) If the increase is >=5% highlight the cell in "RED".
Thanks for helping.
I have a workbook with two sheets. Each sheet has 5 columns.Columns D and E
change from month to month.
The Column D holds the date mm/dd/yy e.g 11/01/2011.
The Column E hold decimal value which may change every month.
I would like a macro that
1) checks to see if the values have change.
2) Show this change as a percentage. (From column D determine which value in E is the oldest to determine if there was an increase or decrease).
3) If the increase is >=5% highlight the cell in "RED".
Thanks for helping.