Conditional Formatting

[Debra]

I am very unfamiliar with Excel so please forgive me for any incorrect
information, I'll do my best. I have a workbook with 15 worksheets. The first
worksheet has a list of 600 names (summary page). Each of those names will be
duplicated in the other worksheets at another time. Here is what I want to
happen:

When a name from worksheet1 has be entered into worksheets 2 - 15, I would
like the entire line on worksheet1 to be highlighted in yellow. Is this
possible to do?

Any help is appreciated
Thanks,
Debra

 

[~L]

One way is to define a named range on each worksheet other than the summary
page by highlighting the range that contains names, then in the little box in
the upper left where it usually has the address, typing in a word like
"ShA","ShB","ShC" etc (without the quotes).

The named ranges are necessary because references to other sheets or
workbooks are not allowed in conditional formats.

After you have all your named ranges defined, for your conditional format
highlight the first row with a name in it (let's say A2 for the sake of this
example).

Format the cells by formula using:

=(countif(ShA,$A2)+countif(ShB,$A2)+countif(ShC,$A2)+countif(ShD,$A2)+countif(ShE,$A2)+countif(ShF,$A2)+countif(ShG,$A2)+countif(ShH,$A2)+countif(ShI,$A2)+
countif(ShJ,$A2)+countif(ShK,$A2)+countif(ShL,$A2)+countif(ShM,$A2)+countif(ShN,$A2))>1