Hi,
I am creating a macro in Excel to extract some information from Master excel.
In Master sheet, have some data with the column- 'Target dates' (list of Dates) in it.
I want to compare Target dates with the current date and if the Target dates already breached the current date, then should be highlighted in red.
If Target date has 10 days from the current date, then should be highlighted in amber.
If Target date has more than 10 days from the current date, then should be highlighted in green.
Please help me with the codes.