Mark if between dates

[Burt_100]

Hi,
I need code that will mark column "AN" as "Quote Required" if the dates between A - N are less then 12 years but more than 4 years, I have added an additional page showing the outcome in the example attached.
Many Thanks
Johnny

[YasserKhalil]

Hello Try this code

Please Login or Register  to view this content.

[ImranBhatti]

Why not a formula like this in AN2?

=IF(AND(YEAR(A2)-YEAR(N2)<12,YEAR(A2)-YEAR(N2)>4),"Quote Required","")

[Burt_100]

Hello Try this code

Please Login or Register  to view this content.

Works great, I have just worked out that I need the background of the call coloured blue, Is this also possible?

[YasserKhalil]

Yes it is possible
Just try edit this line to add a line for that task

Please Login or Register  to view this content.

To

Please Login or Register  to view this content.

[Burt_100]

Sorry just run across another problem - From time to time the date cells will contain " / / " is it possible to skip when this is the case?

[YasserKhalil]

May be

Please Login or Register  to view this content.

[Burt_100]

For some reason it is picking up the " / /" is there code that will ignore if a date is not inputted?

[YasserKhalil]

May be before this line

Please Login or Register  to view this content.

You can add a condition of checking date using IsDate function