Get color of cell

(1) Share

Report

Posted on by CU17011800-0

is it possible to get the colour of a cell in excel, from power automete desktop?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

trice602 15,402 Super User 2025 Season 2 on at

Like (0)

Report
Hi,

Yes you can do that with the following steps:

Open your Power Automate Desktop flow.

Use the "Launch Excel" action to open an existing workbook or create a new one.

Use the "Set color of cells in Excel worksheet" action in advanced section:

Select the target cell or range.

Specify the formatting type, such as font color, background color, or other properties.

Save and close the Excel file.

------------------------------------------------

⭐ If this was helpful, please like and mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
trice602 15,402 Super User 2025 Season 2 on at

Like (0)

Report

Sorry - just realized it is GET not SET. You can use a Python script in PAD like this:

from openpyxl import load_workbook

# Load the workbook and select the sheet

workbook = load_workbook("%ExcelInstance2%")

sheet = workbook.active # Replace with sheet name if needed

# Get the cell

cell = sheet["A1"]

# Get the fill color

fill_color = cell.fill.start_color.rgb # Hex color code (ARGB format)

# Display the color

print(f"The color of cell A1 is: {fill_color}")

Was this reply helpful? Yes No
CU17011800-0 2 on at

Like (0)

Report

what I need is to get the background colour of a cell.

I would need to get the yellow colour from column A, and then the blue colour.

Was this reply helpful? Yes No