Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Get color of cell

(1) ShareShare
ReportReport
Posted on by 2
is it possible to get the colour of a cell in excel, from power automete desktop?
  • CU17011800-0 Profile Picture
    CU17011800-0 2 on at
    Get color of cell
    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.
  • trice602 Profile Picture
    trice602 11,848 on at
    Get color of cell
    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}")
  • trice602 Profile Picture
    trice602 11,848 on at
    Get color of cell
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,580

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,909

Leaderboard