+3Hello,
I'm working on an organizational chart based on an Excel spreadsheet, and I'd like to add some visual cues. Specifically, I'd love to color-code individuals if they belong to a certain tier within our team. Is it possible to set up a rule that says, 'If this cell in this column contains this specific text, then color the person's box in the org chart this color'?
Thanks
Best answer by Humas1985
Hi
You can create an excel by structuring with a column specifying each
individual's tier or category
User-1|Manager|Tier-1
User-2|Assoicate|Tier-2
Upon the prep, upload the excel into data, org chart. Then map the appropriate columns, such as Name, Role, and Tier
Then, apply conditional formatting by selecting the org chart, clicking Advanced Shape Settings, and navigating to Conditional Formatting. Create new rules based on the Tier column, specifying fill colors for each tier, Tier-1: Blue, Tier 2: Green, Tier 3: Yellow.
Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards
+24Hi
You can create an excel by structuring with a column specifying each
individual's tier or category
User-1|Manager|Tier-1
User-2|Assoicate|Tier-2
Upon the prep, upload the excel into data, org chart. Then map the appropriate columns, such as Name, Role, and Tier
Then, apply conditional formatting by selecting the org chart, clicking Advanced Shape Settings, and navigating to Conditional Formatting. Create new rules based on the Tier column, specifying fill colors for each tier, Tier-1: Blue, Tier 2: Green, Tier 3: Yellow.
Hope this helps - Happy to help further!!
Thank you very much and have a great one!
Warm regards
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
A Lucid account is required to interact with the Community, and your participation is subject to the Supplemental Lucid Community Terms. You may not participate in the Community if you are under age 18. You will be redirected to the Lucid app to log in.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
