Conditional Formatting VBA (Compare 2 column)

I am adding in a column in a long macro and then I need to add conditional formatting to that column in VBA. Struggling.

I need to compare column V to lastrow to column P to lastrow and have it one color or another.

This is part of what I had so far but not sure how to define i to mean to use the current row... so I got stuck. Hellllp =D

Please Login or Register  to view this content.

I forgot to put that I used record to see how it did it and it works but it is really...hefty code. Also I have no clue where the .color values come from so I can't cahnge them easily..what are these long numbers? HEX and RGB won't work.

Please Login or Register  to view this content.

So the way this works is:

Please Login or Register  to view this content.

As though you were doing it manually, this is saying that the range to be conditionally formatted will span from V2 down to the last row in that column.

Please Login or Register  to view this content.

It then applies the formula

Please Login or Register  to view this content.

to each cell in the selection, so this addresses your question re: how to define I. In terms of colour, you can use the RGB function here

Please Login or Register  to view this content.

Hope that helps.

Dan yes! Broken down that made so much more sense, also made me realize that I always screw up conditionally formatting (because you need that first...starting cell, whatever it is called (the =V2 part).

I got it working with

Please Login or Register  to view this content.

Thank you kindly, also TMS thanks for replying even though I didn't end up having to use a sample =D

You're very welcome, and I'm glad that you understood what I was getting at with the starting cell part. I wasn't quite sure how I would explain it it if you didin't know what I was talking about. And thank you for posting the solution - it will help others in a similar situation, I'm sure.

What I did do was explain the Long numbers. That's the colour code that Excel understand and it covers the full RGB spectrum. What you've used in your solution above is the ColorIndex property - that has a spectrum of (I think) 56 colours and I believe it's a legacy feature from an older Excel version. But the best solution is the one that works! Thanks for letting us know.