Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,961 questions
I want to be able to click on an acronyn cell and it then hightlights the cost centres attached to that acronyn
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(310.4, 88%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJS%3C/text%3E%3C/svg%3E)
Jeanette Seeds
0
Reputation points
We have a list of teams with several cost centres attached to each team. I want to be able to click on a team and when I do, I want it to highlight the predetermined cells of the cost centres attached to that team.
I have two lists - 1 list a cost centre list and 1 list a team list.
The team name may not be reflected in the cost centre name.
Excel
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,983 questions
{count} votes
-
Emi Zhang-MSFT 25,546 Reputation points Microsoft Vendor2024-11-06T08:23:25.04+00:00 Hi, Did you have the source table to confirm which team matches with those cost centers?If you know the conditions, try creating a drop-down menu to help you.
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 53%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
Barry Schwarz 3,071 Reputation points2024-11-06T08:48:14.6266667+00:00 A macro seems like a feasible approach.
How is a cost center attached to a team? How do you want the cells highlighted?
-
Jeanette Seeds 0 Reputation points
2024-11-07T01:03:07.9133333+00:00 I have 1 list that is a cost centre list
I have another list that are acronyms/team names
I want to be able to click on one of the team names and the cost centres attached to that team will be highlighted in a different color
-
Barry Schwarz 3,071 Reputation points
2024-11-07T01:58:43.61+00:00 What do you mean when you say a cost center is attached to a team? What is in the excel spreadsheet that identifies this attachment?
-
Jeanette Seeds 0 Reputation points
2024-11-07T19:53:23.9866667+00:00 I want to be able to click into the cell that says RCACT and when I do I want the RCACT cost centres to change into a different colour. When I click into the cell that says CYMHS I want them to be highlighted. Nothing is attached in the spreadsheet, all they are sorted lists, they have not been formatted in anyway as yet.
Sign in to comment
Sign in to answer