Update a Customer Field based On Estimate

Update a Customer Field based On Estimate

Hi,

I want to classify customers based on the estimate provided to them

E.g. if a customer is not given any estimate for say 6 months ., It should be marked as silent 

And if customer is given quotation in last 2 months ,then it is active


How can we do that ?