I do have some conditional rules for the colour of the cards. But that is not relevant here.
In order the get Overdue, Today and Future to be coloured Created a relation column to a database and then format the display column of that database.
You can also use select columns (But if you put a formula on that column you can not then control what color each select option is.)