title: Format Painter Not Working - Conditional Formatting
body: <p>I am trying to copy conditional formatting of cell C1 &amp; C2 (please see the image below) onto the rest of the C cells, but the Format Painter appears to be not doing the job.</p>
  
  <p>As you can see, I am trying to compare column A and C with each other. If the two cells match, I'd like the cell in column C to turn green.</p>
  
  <p><img src="https://i.stack.imgur.com/RIHs2.png" alt="enter image description here"></p>
  
  <p>I have used conditional formatting for the first two cells and want to extend it to the rest of that column.</p>
  
  <p>Here's the file if you'd like to see it:
  <a href="http://www.mediafire.com/?vv707p3do93rur8" rel="nofollow noreferrer">http://www.mediafire.com/?vv707p3do93rur8</a></p>