Hi again,

Am Fri, 28 Mar 2014 13:41:42 +0000 schrieb Moideen:

When i insert new row above current date (Eg. Row E10, Inserted New Row)
both rows are hightlighted, Please note When i inset new row below
current date it working fine

please have another look for the workbook "Today" on OneDrive.
I changed the formula into the conditional formatting.

Regards
Claus B.
--
Vista Ultimate SP2 / Windows7 SP1
Office 2007 Ultimate SP3 / 2010 Professional