VBA code for comparing dates in column E and F, then highlight the date

[Jimmy1709]

Hello,

I am new to the VBA programming.I need to code which compares dates from column E with respective date in column F then highlight green if date is greater and Red if date is lower. The code should stop on empty rows.

[BadlySpelledBuoy]

Hi and welcome.

Is there a reason you're looking for VBA to do this rather than just use conditional formatting?

If this something you need to happen when you enter dates in a row, i.e. entering the date is the trigger? Or do you want to click a button when all the data is in and apply the highlight at that stage?

BSB

[Jimmy1709]

Yes, I already have a macro written by someone, I need to make changes to it to accommodate this change to improvise.

Hi and welcome.

Is there a reason you're looking for VBA to do this rather than just use conditional formatting?

If this something you need to happen when you enter dates in a row, i.e. entering the date is the trigger? Or do you want to click a button when all the data is in and apply the highlight at that stage?

BSB

[BadlySpelledBuoy]

It might be useful if you attach a desensitized version of your workbook and include the macro you already have.
It's often easier to add to what you have than start from scratch only to have you come back and ask if we can combine the two for you.

To attach your workbook, click on "Go Advanced" below your reply then scroll down and click where it says "Manage Attachments" to open the upload window.

BSB

[Jimmy1709]

Hello, i am afraid I can’t share the sheet here. I don’t have access to excel outside work. I can use that only in office and can’t login to external sites from office.
If you could help me code these, I will combine myself. Basically, I want to understand how to name variable and write If loop here. Thanks in advance for your help.

It might be useful if you attach a desensitized version of your workbook and include the macro you already have.
It's often easier to add to what you have than start from scratch only to have you come back and ask if we can combine the two for you.

To attach your workbook, click on "Go Advanced" below your reply then scroll down and click where it says "Manage Attachments" to open the upload window.

BSB

[dangelor]

Possibly...

Please Login or Register  to view this content.

[Jimmy1709]

Dangelor - Thank you so much, it seems working fine. Just one error, it is highlighting heading row as well, how to change it to skip headings. Also, Can you please help me understand what the below code does actually. Thanks in advance.

lRow = Cells(Rows.Count, 5).End(xlUp).Row
Set r = Range(Cells(1, 5), Cells(lRow, 5))

[dangelor]

Please Login or Register  to view this content.

[Jimmy1709]

This is perfect now, Thank you so much. I learnt how to end selection at last row and If statement.

[bakerman2]

To cut down on typing.

Please Login or Register  to view this content.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.