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: