SET color Range without application scope

[oumayma_lajili1 (oumayma lajili)]

I have an error with application excel scope , can i use setcolor range out of application scope

[1996 (Neelima G)]

Hi @oumayma_lajili1,

Try this below Link for set colour Range without using application Scope:

Color excel cells without Excel Application Scope

Heyy @dias97 Here is the code Dim excel As Microsoft.Office.Interop.Excel.Application Dim wb As Microsoft.Office.Interop.Excel.Workbook Dim ws As Microsoft.Office.Interop.Excel.Worksheet excel = New Microsoft.Office.Interop.Excel.Application wb = excel.Workbooks.Open("C:\Input\inputdata.xlsx", [ReadOnly]:=False) excel.Visible = True ws = CType(wb.Sheets("Summary"), Microsoft.Office.Interop.Excel.Worksheet) ws.Activate() ws.Range("A2:A6").Interior.Color = RG…

Hope this helps,If it works, mark it as solution.

Thanks,
Neelima.

[oumayma_lajili1 (oumayma lajili)]

Thanks ,
i want to add a condition on each range to color it.
can you help me to add this condition
Thanks a lot