How can i automatically get the result needed shown in the attached workbook with VBA.
i have attached two sheets, the first one is the currently what i have and the next one is the desired result that i am looking for.
i need to get this done with VBA. including the coloring where the condition is if those cells starting from C4 with percentage % if itis i above 0.7 then green and if lower then 0.1 then orange and the rest no color.
the first row is formatted with superscript and second row is changed to bold and italic is removed.
any help is appreciated.