Current year for condtional formatting

[AliMacca]

Hi

I have a spreadsheet that I| need it to pick up the current month in gthe
current year and change colour. I am halfway there with getting it to pick up
the month but it is also picking up the next year when inputted - how do i
only get it to pick up the current year?

 

[PvdG42]

Hi

I have a spreadsheet that I| need it to pick up the current month in gthe
current year and change colour. I am halfway there with getting it to pick
up
the month but it is also picking up the next year when inputted - how do i
only get it to pick up the current year?

Are you writing a .NET application that accesses a spreadsheet, or are you
accessing the spreadsheet as the user?