I just didnt know excel autofilters can be used in such a powerful way. With the additional sheet for settings you can globally assign the color codes and criteria to trigger actions - what a time saver:
Excel dashboard filter colors example template
