Customer Retention/Loyalty program

I would like to do some customizations in the automation program such that the program will be able to accumulate the points automatically in a new spreadsheet with a list of customer datas.

For example, every order with 50 quantity of clothes will automatically generate 100points in a new spreadsheet.
Any new data added will automatically transfer and generate the data in the spreadsheet

Another help i need is, for example, if there were more than 100 quantities, it will auto highlight the data in blue color on the spreadsheet itself.
200 quantities = red

I have minor knowledge in excel. Thanks and you may email me at [email protected]
Appreciate it. I need it urgently.

those red and blue colors = conditional formatting
I made a "table" of your data.
With that table I created a pivottable for your points in the next tab

there are no macros involved. The file has a ".xlsx"-extension.
perhaps, later, you need a macro to update the pivottable automatically