See how your project tasks are progressing at a glance with conditional formatting rules. For example, add colors to make completed tasks stand out from tasks that haven’t been started or are in progress.
On the Single color tab, under Format cells if, select Text contains.
In the box under Text contains, type Complete.
Under Formatting style, click the list to choose if you want the background or text to be colored.
(Optional) Click Text color format_color_text or Fill color format_color_fill to assign a custom text or background color. If needed, you can specify a color for the text and a color for the background.
(Optional) Click Add another rule and follow the same steps to add more rules. For example, assign a red background to Not started tasks and an orange background to In progress tasks.
Wouldn’t it be cool if customers could simply ask Alexa to look up the contact information for your business or team? Now you can build a skill that enables just that scenario using our team lookup skill template.
This template's sample data lets you search for Alexa evangelists and solutions architects by name and by city. So you could say, “Alexa, ask Team Lookup to find me an evangelist in Seattle,” and your skill would respond with the names of the evangelists along with their Twitter, LinkedIn, and GitHub handles. You could also say things like, "Alexa, ask Team Lookup: Who is Dave?" and "Alexa, ask Team Lookup for Amit’s Twitter handle."
Make It Your Own
You can replace the sample data included in this template and make the skill all your own. See the customization section in our tutorial for more details. Here are a few ideas.
Scenario 1: Just Replace the Data and Publish
Imagine you are a real estate company and you'd like to enable your customers and prospects to find a local agent by just talking to Alexa. You can take this template, replace it with your data, then publish it. Then anyone with access to a device with Alexa can just say, “Alexa, ask My Broker to find me an agent in New York."
Scenario 2: Replace the Data and Use It Privately
The first scenario entails publishing your skill and making it available in the Alexa Skills Store. But you could also use your skill privately to look up information for your friends and family: "Alexa, ask People Finder: What's Jessica's Twitter handle."
Scenario 3: Replace the Data, Add More Features, and Publish
Finally, you can also use the sample code as a base and build up—say, by adding more information types like email and Instagram handles. You can also add search by geolocation, so it would return results for people who are currently in a given city.
Visit our GitHub page to start building with the new team lookup skill template. Once you publish your skill, mark the occasion with a free, limited-edition Alexa dev shirt.
Build a Skill, Get a Shirt
The Alexa Skills Kit (ASK) enables developers to build capabilities, called skills, for Alexa. ASK is a collection of self-service APIs, documentation, tools, and code samples that make it fast and easy for anyone to add skills to Alexa.
Developers have built more than 10,000 skills with ASK. Explore the stories behind some of these innovations, then start building your own skill. Once you publish your skill, mark the occasion with a free, limited-edition Alexa dev shirt. Quantities are limited.