Current year for condtional formatting

's Computer Specifications

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?

's Computer Specifications

"AliMacca" <(E-Mail Removed)> wrote in message
news:BE278FE9-7702-4F50-8F0C-(E-Mail Removed)...
> 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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Condtional Formatting	Sam Harman	Microsoft Excel Discussion	2	22nd Jul 2011 01:53 PM
Condtional Formatting	bollard	Microsoft Excel Worksheet Functions	2	24th Apr 2008 03:16 PM
Condtional Formatting	PAL	Microsoft Excel Worksheet Functions	11	3rd Jan 2008 07:34 PM
Condtional formatting	=?Utf-8?B?NjhtYWdub2xpYTcx?=	Microsoft Excel Worksheet Functions	2	15th Apr 2005 09:46 PM
Condtional formatting in VBA help!	Simon Lloyd	Microsoft Excel Programming	0	9th May 2004 10:30 AM