VBA Color dates

  • Hello,

    I have a question, because I have a problem regarding a VBA code

    I found a code that does only partially what I want.
    I'm trying to highlight dates that are equal or lower then the current date (this date is on a different sheet, called Setup and the date is in cell "F3")
    If there is no date in the range given no formatting should take place.
    And only the range given should be highlighted, and not the rows in between the range.

    Can somebody assist me with this problem, it would be highly appreciated.

    The Code:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!