Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting
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,$A 2)+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 "Debra" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |