Font format based on condition

What are you trying to achieve?

Hi Community,
I’m inserting some google sheet data into google slides, and I want to modify the font based on a condition.
I have a scenario with several ‘search rows’ modules, each of this modules is connected to an array aggregator. Then all the variables are defined in a JSON module, after that I added a JSON parse module and a Google slides module (create from template).
The variables in the JSON module have this format:
{{formatNumber(parseNumber(58.array[2].3))}}%-{{formatNumber(parseNumber(58.array[2].6))}} ({{formatNumber(parseNumber(58.array[2].10))}})
I want row font to be bold if ‘10’ is equal or higher than 60.

Steps taken so far

I tried creating an app script in Google Slides (outside make.com) and then adding an http module in make.com, but it does not work.
Do you have any recommendations?
Thanks in advance!!

Try using the native Conditional Formatting feature in Google Sheets.

For more information, see Use conditional formatting rules in Google Sheets - Computer - Google Docs Editors Help

Hope this helps! Let me know if there are any further questions or issues.

@samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

Thanks for your answer!
Actually it´s not working, I´m still getting the same font of the original template.
I send you some screenshots to understand a bit better the case.I´ll see:

  1. Scenario
  2. Variable definition
  3. Replace of placeholders in Google Slides (in make.com)
  4. Result in updated template. The area selected in red should be bold as Opportunity score is higher than 60, it´s 67




I hope this extra info helps to understand better the issue :slight_smile: