Hi,

I have customer based data with having date of birth in dd-mmm-yyyy format ( 20-oct-1980 ), I want formula / macro to highlight entire row if date of birth match with todays date with red colour. also date of birth if comming next 5 days in green colour.

Pls help.