VBA code for conditional formatting

Hi,

I have a data from cell C4:Fxxxx (the last row is defined as xxxx because, each time the row gets chagned, it's not constant).
I am looking for some assistance on how to define formula for conditional formatting.

If cell value of F4 <=500000, corresponding cell (ie C4 in this situation) should be green color, similarly it should do for all cells in that column.

I have written the following code, but with no luck. Any assistance!!!

Here is my code

Please Login or Register  to view this content.

Thanks!

Why not just apply the Conditional Formatting directly to column C? You can also use the macro recorder to capture to code and add it to your macro.