I'm working on a product that manage workers certificates, and so we have a table with ALL certificates where you can find cards for each one
Each card has: Certificate name, Next due date (29 days before expiration date), number of people with that certificate, Status badge and a Kebab button to eliminate or export that certificate. (Lets call this Parent table)
Then if you click on any certificate you will officially enter into that certificate and see everyone who has it (Lets call this child table)
The problem: Parent and child should use the same "Status and color coding badge"
Current status in Parent table are: All expired, "N" expired, Up to date, unassigned
Current status in Child table are: Expired, Next due, Up to date
So as you can see the conflict is between "N" expired on the parent table and "next due" on the child table
Possible solution: Eliminate "All expired" status and use color red for "1 expire and all"