In last week’s video I showed you how to add traffic lights to a Dashboard or Tracker. However, the demo included a feature, placing an image inside a cell, which is currently only available to 365 Beta users.
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 week’s video, in the name of inclusivity, I show you once again how to add a traffic light to your Dashboard or Tracker and have it automatically change colour as the numbers change. But this method should work for everyone.
The formulas used in this video:
=IF(PercentTarget<0.8,1,IF(PercentTarget>=1,3,2))
=INDEX(Setup!$A$2:$A$4,Setup!$C$1)
=LightColour