Override conditional formatting

Hi Chemist,

Thanks for your help. The problem that i have with the standard formatting though is if the user paste data form other workbooks with formatting it changes the conditional formatting colour. I cannot lock the cells as the users have to be able to enter rows and paste data. Any other way of doing the formatting please?

Many Thanks

Chemist thank you very much I am very greatful

Hi chemist

Did you have some time to have a look for the vba code please?

Many thanks

Can anybody please help? I need to complete this project today and I just need the conditional formatting sorted.

Many thanks

Hi Royuk,

Thank u very much for the code.I am still working on the project and I am goin grey.
I made a little mistake in my cell range, sorry. All the cells are on row 4 and not row 1 which I can twea, however It looks like it is focusing on only one row. As the data will be in 3000 rows how that would work??obviously for each of the above statement when u moving to the next row the formatting will continue.

Many thanks
Greekboyuk

Hi Roy,
You are the master thank you even so much. I have tweaked your code and added some more conditions and it works perfectly. Thank u again I am amazed. Wanted to say thank u to everyone that tried to help to. Apologies for not responding I have been doin some 14 hours shifts at work and now I am so happy with your help.
Off topic:
Roy I am looking to learn Vba in extreme depth like u all have. Do u know whether there are any training material or even courses (preferably DVDs) that I can start developing my knowledge? I have had a look in one of lindas website (vba in depth) but it is not really in depth it isn't showing a lot. Could you or anyone else advise me?

Thanks a lot again