Conditional Formatting not updating when pasting values

Hi,

I have VBA code that specifies several colours based on a cell value. If you enter this value into a cell the colour changes as it should. However if you copy a cell (or range) from another sheet and paste it (using paste special values) into the workbook even with the same formatting the cell's condition will not change colour.

Is there a way for this pasted data to update automatically?

Code for reference:

Please Login or Register  to view this content.