Skip to main content
Cadet | Tier 2
April 25, 2025
Question

How to change Excel cell color with the Excel advance package

  • April 25, 2025
  • 5 replies
  • 216 views

I want to know how to change Excel cell color using the Excel advanced package.
I found similar topics, but the information was from 2 years ago, so it seems outdated.

If the Excel advance package can’t be used,I’d like to know an alternative method.

Best regards

5 replies

Marc Mueller
Most Valuable Pathfinder
Most Valuable Pathfinder
April 25, 2025

Hi ​@TKD-M,

I think it is not possible with the Excel Advanced package right now!

Python would work.

 

import openpyxl
from openpyxl.styles import Font, Alignment, Border, Side, PatternFill

data_fill = PatternFill(start_color='AED6F1', end_color='AED6F1', fill_type='solid')

 

Another way here:

 

Cheers

Marc

🤝Let's connect on LinkedIn: https://www.linkedin.com/in/developer-marc-mueller >>>>>>>> 📺Check out my YouTube channel - https://youtube.com/@AutomationDevelopmentEasy
Cadet | Tier 2
April 25, 2025

Very simple, just click on the color and change the cell

Padmakumar
Premier Pathfinder | Tier 7
Premier Pathfinder | Tier 7
April 25, 2025

Hi ​@TKD-M ,

 

Please make use of the below mentioned package from Bot store to achieve this.

 

Excel Formating Operations

 

 

Padmakumar
Aaron.Gleason
Automation Anywhere Team
Automation Anywhere Team
April 25, 2025

Remember that there are other alternatives. Things like conditional formatting, built into Excel. You can also use pre-formatted template files.

Navigator | Tier 3
April 28, 2025

The best alternative is to create a simple VBA Macro inside Excel and use the "Run Macro" action from the Excel Advanced package to change cell colors.