Hi,
Haven't used Excel in ages now and can't remember how to do anything
I basically have a huge list of dates in column A (in date format) and want to highlight the cell red if the date expires falls within the next 30 day period from today. E.g. if the date was 22/10/2010 then I'd need this red, due if the date was 01/05/2011 this would contain no highlighting.
Thanks
Haven't used Excel in ages now and can't remember how to do anything
I basically have a huge list of dates in column A (in date format) and want to highlight the cell red if the date expires falls within the next 30 day period from today. E.g. if the date was 22/10/2010 then I'd need this red, due if the date was 01/05/2011 this would contain no highlighting.
Thanks
