Conditional formatting Highlight Past Year...?

[pipsmultan]

Greeting to all respected members of this great forum

i am trying to apply Conditional formatting on month and year from Cell "S6 & X6" , Which i am not successful to do so

The Date & month part is working fine to Highlight the dates and Month which starts from 1st to 14th of every current month date and from 15th to 31th of previous month date.

BUT

The YEAR part cell "X6" is NOT working OK it Highlight the current year which i dont need. what i m trying to solve is it to Highlight previous PAST Years only not the current years.
Highlight previous years means (i.e 2014, 2013,2012,2010.....). (NOT to Highlight Current year 2015)

Plz find the attachment
joining Date Hihghlight 2.xlsx

cant not figure out the solution

any kind help will be highly appreciated

Regards

[pipsmultan]

any solution will be highly will be highly appreciated

need to update following code

Please Login or Register  to view this content.

Regards

[Tony Valko]

Try this...

=AND(YEAR(D12)<YEAR(NOW()),TEXT(EOMONTH(D12,(DAY(D12)>14)+0),"MMMM")=$S$6)

[pipsmultan]

Try this...

=AND(YEAR(D12)<YEAR(NOW()),TEXT(EOMONTH(D12,(DAY(D12)>14)+0),"MMMM")=$S$6)

Dear Tony Valko: your quick reply is highly appreciated. i try the cod but when i change the Year from 2015 to 2016 and soon, it don not highlight the past year date of 2015

any solution of it

Reagrds

[Tony Valko]

Opps!

I didn't see that the year number was entered in a cell!

Try this version:

=AND(YEAR(D12)<X$6,TEXT(EOMONTH(D12,(DAY(D12)>14)+0),"MMMM")=$S$6)

[pipsmultan]

Try this version:

=AND(YEAR(D12)<X$6,TEXT(EOMONTH(D12,(DAY(D12)>14)+0),"MMMM")=$S$6)

Beautiful working like a charm thanks a lot "Tony Valko" i am very grateful to you for your kind quick help
highly appreciated

Thread marked as solved and Reputation added

Best Regards

[Tony Valko]

You're welcome. Thanks for the feedback!