web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / customize cell format ...
Power Automate
Unanswered

customize cell format when adding a row to an excel table

(0) ShareShare
ReportReport
Posted on by 4

Is there a way to set the font color in an excel cell when adding a row from power automate?  Here is an example

Excel Table:

column 1     column 2     column 3

ABC             123               XYZ

ABC             123               #%$

 

I want column 3 to be highlighted in some way because it is the only value that changed from the previous update.

 

I'm using "get changes for an item or f

 

 

 

Categories:
I have the same question (0)
  • v-xiaochen-msft Profile Picture
    Microsoft Employee on at

    Hi @sromley ,

     

    You can write script in web excel and run the script in power automate if you have license.

    vxiaochenmsft_0-1669692305833.png

    vxiaochenmsft_1-1669692367793.png

     

    vxiaochenmsft_2-1669692401802.png

     

    Best Regards,

    Wearsky

  • sromley Profile Picture
    4 on at

    Ok, I get that.  Where can I find info on how to write scripts.  I only want to target cells in the columns that have changed from the previous extract.

  • v-xiaochen-msft Profile Picture
    Microsoft Employee on at

    Hi @sromley ,

     

    Sorry, I'm not an expert of excel script and unable to provide you with further assistance.

    Maybe you can find the answer in some excel forums. 🙂

     

    Best Regards,

    Wearsky

  • MichaelAngeloP Profile Picture
    6 on at

    I can write you the script.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 592

#2
Valantis Profile Picture

Valantis 340

#3
11manish Profile Picture

11manish 284

Last 30 days Overall leaderboard