title: Conditional formatting of entire table in FlexTable
body: <p>What I want to do is conditionally format an entire table in r based on a value, I am currently trying this with flextable:</p>
  
  <pre><code>#some data 
  SalesData&lt;-data.frame(Appliance=c("Radio", "Laptop", "TV", "Fridge"), ThisYear=c(5,25,5,8), LastYear=c(6,20,5,8))
  
  #use flextable to conditionally format the data so that anything in the ThisYear column more than 10 is light blue
  library(flextable)
  
  SalesData&lt;-regulartable(SalesData)
  SalesData&lt;-bg(SalesData, i = ~ ThisYear &gt;10,j= ~ ThisYear,bg = "light blue")
  SalesData
  </code></pre>
  
  <p>The tables I have can be quite large so how can I apply this to the whole table without have to specify the formatting for each individual column? </p>