conditional formatting

[rrowdy]

I have a workbook with 50 identical sheets with conditional formatting, with 1 summary sheet. Is there any way that the summery sheet could reflect the red colour that appears on any of the 50 sheets.....say if a line on the summary sheet is named the same a work sheet.

[Palmetto]

If you maintain a list of the worksheet names you could use Conditional Formatting, formula option.

Say you kept the list of sheet names on a sheet named "SheetList" , in the range of cells A1:A10

If Sheet1, cell A1 contains a matching sheet name we could use this formula in the Conditional Format

=MATCH(A1,SheetList!$A$1:$A$10,0)>0

Set the cell formats to whatever you need.