topic RE: How to set Color to a cell in Excel in Product Forum

How to set Color to a cell in Excel

NagaYaparla — Fri, 24 May 2019 01:08:00 GMT

Hi All, I am trying to fill color to a specific cell in excel, any one has any idea please comment this post. Â Thanks in advance..

Hi, Depending on yourâ€¦

franlem2 — Fri, 24 May 2019 15:51:00 GMT

Hi, Depending on your version perhaps can you set rules into Excel to fill this cell here : https://support.office.com/en-gb/article/apply-create-or-remove-a-cell-style-472213bf-66bd-40c8-815c-594f0f90cd22 If this option does not apply to you, I would recommend to create a VBA Macro to handle it.

... then you run the macroâ€¦

franlem2 — Fri, 24 May 2019 15:52:00 GMT

... then you run the macro from BP with the Excel VBO.

Or you can add action toâ€¦

AndreyKudinov — Fri, 24 May 2019 20:26:00 GMT

Or you can add action to excel VBO to do it, should be easy, codeÂ was somewhere on the forum if I remember correctly.

Code Dim xl, wb, ws, r, i, fâ€¦

nadiim — Sat, 25 May 2019 15:26:00 GMT

Code Dim xl, wb, ws, r, i, f as object Try Â Â xl = GetInstance(Handle) Â Â Â if Workbook_Name = "" then Â Â Â Â wb = xl.activeworkbook Â Â else Â Â Â Â Â wb = xl.workbooks(Workbook_Name) Â Â Â Â Â Â wb.activate Â Â end if Â Â Â ws = wb.activesheet Â Â if Ref.Trim = "" then Â Â Â Â r = ws.usedrange Â Â Â else Â Â Â Â Â Â r = ws.range(Ref) Â Â Â end if Â Â Â i = r.Interior Â Â Â i.ColorIndex = Background_Colour Â Â Â f = r.Font Â Â Â f.ColorIndex = Foreground_Colour Catch e As Exception Â Â Â Success = False Â Â Â Message = e.Message Finally Â Â Â xl = Nothing Â Â Â wb = Nothing Â Â Â ws = Nothing Â Â Â i = Nothing Â Â Â r = Nothing Â Â Â f = Nothing End Try Â

RE: How to set Color to a cell in Excel

Juan_ManuelFon1 — Thu, 18 Jun 2020 17:39:00 GMT

You can use the set cell color Action In the MS Excel VBO.

------------------------------
Juan Manuel Fonseca
Rpa developer
Freelance
America/Mexico_City
------------------------------

RE: How to set Color to a cell in Excel

SofíaRoldán — Thu, 17 Jun 2021 11:53:00 GMT

Hi!
Where can I find the MS Excel VBO-set cell color Action for downloading?
Thanx

------------------------------
SOFÍA ROLDÁN GARCÍA
------------------------------

RE: How to set Color to a cell in Excel

KarolPietrzyk1 — Thu, 24 Jun 2021 12:17:00 GMT

Create additional action in excel vbo

code:
For Each row As DataRow In rowscoll.Rows
GetWorkbook(handle,Nothing).ActiveSheet.Cells(row.Item("Value"),colref).Interior.Color = RGB(Red_Value, Green_Value, Blue_Value)
next row

Inputs to the action:

Action:

ColRef is number of the column
rowscol is collection of row numbers to color

------------------------------
Karol Pietrzyk
------------------------------