title: R: Conditional Formatting across excel files
body: <p>I am trying to highlight rows of an excel file based on a match from the columns in a separate excel file. Pretty much, I want to highlight a row in file1 if a cell in that row matches a cell in file2.</p>
  
  <p>I saw the R package "conditionalFormatting" has some of this functionality, but I cannot figure out how to use it. </p>
  
  <p>the pseudo-code i think would look something like this:</p>
  
  <pre><code>file1 &lt;- read_excel("file1")
  file2 &lt;- read_excel("file2")
  
  conditionalFormatting(file1, sheet = 1, cols = 1:end, rows = 1:22, 
  rule = "number in file1 is found in a specific column of file 2")
  </code></pre>
  
  <p>Please let me know if this makes sense or if i need to clarify something.</p>
  
  <p>Thanks!</p>