Current year for condtional formatting

  • Thread starter Thread starter AliMacca
  • Start date Start date
A

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?
 
AliMacca said:
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?
Click to expand...

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