Skip to main content
Question

How to change Excel cell color with the Excel advance package

  • April 25, 2025
  • 5 replies
  • 93 views

Forum|alt.badge.img+3

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
Forum|alt.badge.img+17
  • 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


Forum|alt.badge.img

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


Padmakumar
Premier Pathfinder | Tier 7
Forum|alt.badge.img+15
  • 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

 

 


Aaron.Gleason
Automation Anywhere Team
Forum|alt.badge.img+14
  • 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.


Forum|alt.badge.img+4
  • 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.