Auto Sort by Color

[indhrui]

Dear Sir,

I have data of works to be completed. using the conditional formatting i formatted the cells using search function. and i trying to insert auto sort function based 1. type of goods 2.on cell color. i tried but can't find the suitable code. please help me to solve this code. find the attachment for your reference