Examples of 'json payload' to format cells with the Microsoft 365 - Excel object

[JeremyRTDean]

Hi,

I'm using the Microsoft 365 - Excel object and working around all the limitations of Microsoft's limited end points.

The Microsoft 365 – Excel VBO User Guide for the Format Fill action and 'Body' Parameter advises to enter: "The JSON payload with formatting properties"

Does anyone have examples of what these payloads could be?  I'm no JSON expert.

I'm looking for formatting like: Bold Text, and fill with a certain colour etc.

[naveed_raza]

in body you have to pass this JSON String

{
  "bold": true,
  "color": "#4B180E"
}

[naveed_raza]

in you Body you have to pass this value for format fill

{
  "color": "#4B180E"
}

 if you use Format font then you have to use this

{
  "bold": true
}