Thank you!

When I was adding the conditional formatting, I was clicking on the Conditional Formatting button on the ribbon, highlighting "Color Scales" from the drop down, and then choosing any one of the default color scales displayed.


When I copy and paste the values there is no green triangle.