VBA Conditional Format Column to the Left Continuously

[cjvenables]

Hello,

Looking for some conditional formatting code that will let me look to see if the values in column B are greater than, less than, or equal to the values in column A. Then, I'd like column C to do the exact same thing with column B, and so on.

The column rows can be dynamic
Less than column is green
Equal to is no fill
Greater than is red

Thanks!

 

[BigC]

You don't need VBA for this - basic CF formula will do the trick.
Select the entire range of cells to be Conditionally formatted and then create/apply the CF rule as if it only applied to the active cell (just ensure that you do NOT include a $ to anchor the column reference in the formula, and the column references will change relatively in each cell across the page - even though you won't see this happening)