Hassan,

Sorry i forgot to mention, i've tried the Conditional Formatting and:

1: I will need more than 3 conditions in the future.

2: I couldnt get it to apply the conditions properly.

I was hoping there would be some VBA code that would do this for me.

Cheers,

Darren


*** Sent via Developersdex http://www.developersdex.com ***