ExcelBanter - Conditional formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Conditional formatting (https://www.excelbanter.com/excel-discussion-misc-queries/97964-conditional-formatting.html)

Tufail

Conditional formatting

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

Gord Dibben

Conditional formatting

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

All times are GMT +1. The time now is 02:47 PM.