Windows 10, MS Office 2016.
When I Copy & Paste cell with Conditional Formatting the color changes in the new cells.
Example: 5% should be a reddish hue, but it comes out as green. So worlds apart. I’m getting into conditional formatting at my Supervisor’s request, and I also find it very interesting and useful.
I tried Raystafarion’s answer from 2.1.12 but it did not work.
I have tried various solutions from the internet, but to no avail. I’ll bet it’s something simple, but is escaping my rookie eyes.
I am not using any formulas, VBA coding, etc.
Thanks In Advance