Excel: Insert an Image into a Cell (the Non 365 Way)
Add a splash of colour to your Dashboards and KPI Trackers! In last week's video I showed you how to add traffic lights to a Step Tracker. However, the demo included a feature, placing an image inside a cell, which is currently only available to 365 Beta users.
I heard from several people who don't have the feature. But worse than that, if you are a 365 Beta user and you use that feature to add images to your spreadsheet and then give the file to someone running a non-beta version of Excel they don't see the images and any formulas that rely on those images break.
So in this video, in the name of inclusivity, I'm going to show you how to add a traffic light to your Step Tracker and have it automatically change colour as the numbers change. But this method should work for everyone.
🗒 Notes and Resources
Link to Last Week's Video (How to Create Traffic Light Images): • Excel: Add Dynamic Traffic Lights to ...
The formulas that I used in the demos:
=IF(PercentTarget (less than sign) 0.8,1,IF(PercentTarget (greater than sign) =1,3,2))
=INDEX(Setup!$A$2:$A$4,Setup!$C$1)
=LightColour
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#dashboard #tracker #datavisualization #fitness