Community Chat

 View Only
last person joined: 2 days ago 

A space for discussion around the Community site and programs.

  • 1.  Changing Text Color of a cell/row in Google sheet.

    Posted 09-11-2023 16:02

    Hello community,

    I am struggling with a requirement to change the text color (not the background color) of a row or set of rows in a google sheet.

    I searched the same in google workspace (https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/cells) but did not find anything on Text Color updating.

    Any ideas/solutions are most appreciated on the topic.



    ------------------------------
    Rohan Shankar
    ------------------------------


  • 2.  RE: Changing Text Color of a cell/row in Google sheet.

    Posted 09-11-2023 16:22
    Hello,
     
     
    Hope this helps


    ------------------------------
    Leonardo Soares
    RPA Developer
    ------------------------------



  • 3.  RE: Changing Text Color of a cell/row in Google sheet.

    Posted 09-12-2023 06:53

    Hey Rohan Shankar

    Are you using the Google Sheets VBO to achieve this?

    Check this for basic formatting in Google Sheets via API. Looks like you need to pass the details in the API body to update the font color.

    https://developers.google.com/sheets/api/samples/formatting



    ------------------------------
    If I was of assistance, please vote for it to be the "Best Answer".

    Thanks & Regards,
    Tejaskumar Darji - https://www.linkedin.com/in/tejaskumardarji/
    Technical Lead
    ------------------------------



Welcome to our 'Off-Topic' Community Chat!

A space for non-technical chat, tips for using the Community, and news from the Blue Prism Community Team.

This is not a Community for technical or Product related discussion. For a list of available communities, please visit our site map.

Introduce YourselfCommunity Tech TipsMeet The Team