Indication of frequent occurrence of certain text in a time interval

Hello,

I need a help. I'd like to ask if it's possible indication of frequent occurrence of certain text in a time interval.

I'll use the example...I have a table in which I write certain data based on data validation (I attached a simple table for an example).

I'd like to know how often for example the color of the car "blue" or type of engine "diesel" appears for the reporting period in the table (say in three months).

At the same time, I wonder if it is possible to indicate too often writing individual attributes. For example, If I write a blue car more than four times in two months, I get a warning in the form of color coding.

I hope I wrote it so that the question makes sense.

Thank you for any advice

David