Cell Unit TO Be coloured in Excel
i have copied 4 line level items in the sale order to excel sheet using code.now if the quantity exceeds more than 1 i need the particular cell in excel to be colored.how could i achieve this.
Dim ExcelApp As Excel.Application
Dim WorkSheet As Excel.Worksheet
Dim Range As Excel.Range