title: Conditional formatting color gets changed when exporting results
body: <p>I am working with an Excel tool where I click a button to process some files, and then click an "Export Results" button to move my results to a new workbook, format, and save. The Excel tool already has pre-set conditional formatting - <a href="https://i.stack.imgur.com/Go3af.png" rel="nofollow noreferrer">see attached image</a>. When I run the macro to export my results, the pink-red fill color gets changed to an orange-red. What vba code can I use to change the color back to pink-red? I have three different worksheets with varying ranges that conditional formatting needs to be applied to.</p>