Something thing that you often see on dashboards and trackers is progress against target. This is often represented as a numeric value.
But what if you were to add an image of a traffic light to your dashboard or tracker and have it automatically change colour as the numbers change?
Both fun and functional
NOTE: This video uses a feature (Insert > Picture > Place in Cell) which at the time of recording is only available to users on the Microsoft 365 Beta Channel
The formula used in this video: =IF(PercentTarget<0.8,Red,IF(PercentTarget>=1,Green,Amber))