PC Review


Reply
Thread Tools Rate Thread

Current year for condtional formatting

 
 
AliMacca
Guest
Posts: n/a
 
      11th Jan 2010
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?
 
Reply With Quote
 
 
 
 
PvdG42
Guest
Posts: n/a
 
      15th Jan 2010

"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?

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:52 AM.