hi all I have some data in excel file I need if in cell A1 value is highlighted then in cell Z1 value Remove thanks in advance Anu