VBA Macro to filter, sort and mark results

I need a VBA macro that loops through every single industry in a list and for every industry does the following: Take the subtotals 1. Sorts the industry entries per sales growth and Highlights the top highest 5 entries in green and the lowest 5 in red. If the filtered results are less than 10 then highlight top half results in green and bottom half results in red. 2. Then for the same industry sort the entries per earnings growth F1 and highlights the highest 5 in green and lowest 5 in 5 red 3. So the same for F2 4. Extract the entries that have all 3 categories in green and all 3 categories in red in a separate sheet Once done proceed to the next filter entry. See attached file for description. The macro needs to be well written and commented and needs to work for large files with many different industries N.B. To make sure you have read and understood the description I will only consider offers starting with the code word "Carrot".