Conditional Formatting

I Would like to use more than 3 conditional formats but the visual basic code I found on the net only worked if I typed the number in and not if it was the result of a formula. Is there any way of getting it to work with formulae? I Have included the code below:

Please Login or Register  to view this content.