hi, i want use conditional formatting in sheet2, if error in sheet1 A5 is it possible ? thanks
T Tufail Jul 7, 2006 #1 hi, i want use conditional formatting in sheet2, if error in sheet1 A5 is it possible ? thanks
G Gord Dibben Jul 7, 2006 #2 First give Sheet1 A5 a name through Insert>Name>Define. Say, MyName Next, in Sheet2 select a cell or cells and Format>CF>Formula is: =ISERROR(MyName) Select a format and OK your way out. Gord Dibben MS Excel MVP
First give Sheet1 A5 a name through Insert>Name>Define. Say, MyName Next, in Sheet2 select a cell or cells and Format>CF>Formula is: =ISERROR(MyName) Select a format and OK your way out. Gord Dibben MS Excel MVP
