Conditional Formatting different Excel columns without repeating code

Hello,

Here is my problem; I have created a macro in Excel using the Record Macro function. The purpose of the Marco is to apply conditional formatting to about 12 separate columns of numbers. The columns need to be treated separately. The macro wants to create this code separately for each column, as shown here. I don't want this code repeated 12x. I simply want to enter all the columns (e.g. H2:H50 L2:L50 P2:P50 etc.) in the Range line and have the code below apply to all the columns listed but this code does not work for some reason.

Any advice welcome.

Please Login or Register  to view this content.

Hi
wrapping code with code tags makes things easier for all...

to look like this

Please Login or Register  to view this content.