Range["E3:H18"].Select();
ActiveWorkbook.Worksheets["Sheet1"].Sort.SortFields.Clear();
ActiveWorkbook.Worksheets["Sheet1"].Sort.SortFields.Add(Range["F4:F18"], _ xlSortOnCellColor, xlAscending, , xlSortNormal).SortOnValue.Color = RGB(255, 0, 0);
ActiveWorkbook.Worksheets["Sheet1"].Sort.SortFields.Add(Range["F4:F18"], _
xlSortOnCellColor, xlAscending, , xlSortNormal).SortOnValue.Color = RGB(255, 255, 0) ;
using (ActiveWorkbook.Worksheets["Sheet1"].Sort())
{
.SetRange Range["E3:H18"] ;
.Header = xlYes ;
.MatchCase = False ;
.Orientation = xlTopToBottom ;
.SortMethod = xlPinYin ;
.Apply();
}
refer below link to convert vb code to c# (or other language conversion)
http://www.developerfusion.com/tools/convert/vb-to-csharp/[
^]
Happy Coding!
:)