Jul 22 2021 06:54 AM
Jul 22 2021 07:12 AM
Perhaps that could be PivotTable, depends on how your data is structured.
Conditional formatting - see for example here Pivot Table: Pivot table conditional formatting | Exceljet
Jul 22 2021 08:46 PM
It would be easier to come up with a solution without having to re-create the problem ourselves. If you provide a sample dataset maybe someone who thinks this puzzle is worth the challenge.
cheers