Prevent conditional formatting moving if user copy/pastes?

[JumboCactuar]

Hi,
I have a sheet set up which changes colours of cells based on Dropdown box value

Problem is I have 5 drop-down (1 for each day) and people copy paste from Monday to the other days and it breaks the formatting

Example
A2: user input
B2: user input
C2: drop-down box ( option sets conditional formatting for A2:C2)

Then drop-down in F2 sets for D2:F2

Is there a solution to this?
Much appreciated

 

[Joe4]

One option is to disable Cut/Copy/Paste.
See: http://www.vbaexpress.com/kb/getarticle.php?kb_id=373

 

[JumboCactuar]

One option is to disable Cut/Copy/Paste.
See: http://www.vbaexpress.com/kb/getarticle.php?kb_id=373

Thank you, but on this particular sheet I can't use VBA.

I'm just gonna have to make it clear to paste values only.