How to optimize COUNTIF

So every day i paste new uniqe stock that came into a warehouse. In other tab someone would type ean codes of product with date of order. I want my sheet to color cell in the first tab, if product was ordered at least once (and optionally more than once with different colour).

For now, i put =COUNTIF(sheet2!A:A;sheet1!E2) formula in first sheet next to codes of products and it colours this formula green if its more than 0. Instead i could put purple if greater than one and green if equal 1.

I ultimately wanted cell with codes to get coloured, but couldn't figure that out.

My problem now is that it will be heavier as times go and often i dont go back more than a month, because by then every product is gone. I could solve it with copying older formulas and pasting it with ctrl + shift + v, but im searching for a way to automate that or find better solution.