title: R Formattable apply two format to an area
body: <p>I'm trying to use formattable awesome package and get a table with percentages and color scaled on multiple columns.</p>
  
  <p>Here is the code</p>
  
  <pre><code>set.seed(123)
  df &lt;- data.frame(id = 1:10, 
                   a = rnorm(10), b = rnorm(10), c = rnorm(10))
  
  df$a &lt;- percent(df$a)
  df$b &lt;- percent(df$b)
  df$c &lt;- percent(df$c)
  
  
  table_with_percent_but_color_not_scaled &lt;- formattable(df, list(a = color_tile("transparent", "pink")
                       , b= color_tile("transparent", "pink")
                       , c= color_tile("transparent", "pink")))
  
  table_with_color_scaled_but_not_percent &lt;- formattable(df, list(area(col = 2:4)  ~  color_tile("transparent","pink")))
  </code></pre>
  
  <p>Problem is that <code>table_with_color_scaled_but_not_percent</code> don't keep the percentage format : </p>
  
  <p><a href="https://i.stack.imgur.com/ACyDV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ACyDV.png" alt="enter image description here"></a></p>
  
  <p>and <code>table_with_percent_but_color_not_scaled</code> don't keep the same scale for coloring the colors: </p>
  
  <p><a href="https://i.stack.imgur.com/Wq5iV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Wq5iV.png" alt="enter image description here"></a></p>
  
  <p>Ideally I would like to use the <code>area</code> functionality, since my df number of columns and name will change in my final code.
  Any idea ?
  Thanks!</p>