First give Sheet1 A5 a name through InsertNameDefine. Say, MyName

Next, in Sheet2 select a cell or cells and FormatCFFormula is:

=ISERROR(MyName)

Select a format and OK your way out.


Gord Dibben MS Excel MVP

On Thu, 6 Jul 2006 19:24:01 -0700, Tufail
wrote:

hi,
i want use conditional formatting in sheet2, if error in sheet1 A5
is it possible ?
thanks