The attached worksheet explains the problems I’m having.

In addition, is it possible to copy and past conditional formats without it referencing the original cell?
Format Help.xlsx