Putting conditional traffic lights on PowerPoint slides controlled through an Excel model
Putting traffic lights showing either red, yellow or green is an important feature for creating many kinds of slides, e.g. flash reports and PMO status reports. Something like this is easy and simple with SlideFab. Watch the video to learn it.
This video shows how the Excel workbook and the PowerPoint template slide have to be built to create a traffic lights automation with SlideFab. This very detailed video explains the principles and the necessary steps. Of course, nobody wants such a slide but knowing how to use the Shape Condition feature is a valuable skill when working with SlideFab.
Find out why conditional formats make even more sense for heat map automation in this tutorial.
Time needed: 5 minutes.
How to create the traffic lights automation using conditional formats with SlideFab.
-
Creating a PowerPoint presentation template containing the red, yellow and green traffic light signals
-
Set up the Excel model which decides the signal to show
-
Linking the red, yellow and green shape using the Shape Condition functionality
-
Setting up the iteration loop for creating one slide for red, yellow and green
-
Starting the slide automation to create the traffic light slides automatically
In this example SlideFab will create one slide per traffic light setting.
Here you will also find the Excel workbook and PowerPoint presentation file as download. Go ahead and try this out with SlideFab right away! All files are prepared already. They contain the formulas and the SlideFab settings as created throughout the video. If you still need SlideFab, you can download the Lite version for free here.
There are more explanatory “How to” articles on the Tutorial page