title: Is there a way to make some formatting in Google Sheet within R
body: <p>I'm currently on a project aiming to generate some formatted report from R to google sheet. </p>
  
  <p>Now I'm using googlesheets4 package and able to write data into google sheet from R. But is there a way to do some formatting work? like <strong>bold</strong>, <em>italic</em>, add $ sign or conditional formatting and etc.</p>
  
  <p>Here is the example spread sheet I made. </p>
  
  <p><a href="https://docs.google.com/spreadsheets/d/1vp-w5muArvMxHKx4NL-39NMkAHRJCtldXLkUmJqKK2E/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1vp-w5muArvMxHKx4NL-39NMkAHRJCtldXLkUmJqKK2E/edit?usp=sharing</a></p>
  
  <p>the output I want is like this(in sheet2), having $ in spend col, keep integer in kpi cols and conditional formatting on upsell cols</p>
  
  <p><img src="https://i.stack.imgur.com/n1CBW.png" alt="enter image description here"></p>