title: r - Chart Excel-like Cell Highlights Similar to Autoformat
body: <p>If I have a dataframe like so:</p>
  
  <pre><code>            client_1    client_2    client_3
  metric_1    0.49        0.01        0.11
  metric_2    0.04        0.02        0.02
  </code></pre>
  
  <p>Is there a way I can add color to any value that is below the threshold .05 is highlighted in green so the output is like the image below?</p>
  
  <p><a href="https://i.stack.imgur.com/z8A1F.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/z8A1F.png" alt="Basic Excel Highlighting"></a></p>
  
  <p>Or even better - with some basic formatting such as:</p>
  
  <p><a href="https://i.stack.imgur.com/pjsY0.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pjsY0.png" alt="enter image description here"></a></p>