PC Review


Reply
Thread Tools Rate Thread

Colouring cell if it has a specific date

 
 
Shivam.Shah
Guest
Posts: n/a
 
      17th Feb 2010
Hi,

I have a column for each month where the dates are entered on rows. Is
it possible I can color a cell if the date entered in a cell for that
month is 15 days past the end of the month. Like, if in a January
column I enter a date on one of the rows as Feb.20, then the cell
fills with red colour.

I tried doing it using conditional formatting, but don't know how to
say 15 days past end of the month?

Any help will be appreciated! Thanks very much!

Shivam
 
Reply With Quote
 
 
 
 
Shivam.Shah
Guest
Posts: n/a
 
      18th Feb 2010
Hi Russell,

I tried that (in 2003) and it works, but the thing is, the date in my
column is
entered automatically by a macro (upon entering data in the cell to
it's left)...so even though I put a conditional format on the cell,
after the date is entered by the macro, it didn't change colour.

So, is it possible to use a macro that can look in a column and then
colour a date if it is 15 days past the end of the current month?

Thanks for all your help!

Shivam
> > .


 
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
Colouring cell if it has a specific date Shivam.Shah Microsoft Excel Discussion 9 18th Feb 2010 09:44 PM
colouring cell KHAN Microsoft Excel Misc 2 2nd Aug 2008 09:42 PM
colouring a cell andy617 Microsoft Excel Programming 2 11th Jan 2006 03:30 PM
How to update a cell if a specific date is included in a date rang =?Utf-8?B?bWdhdmlkaWE=?= Microsoft Excel Setup 2 8th Oct 2005 12:53 AM
How do I make a cell date specific to input a value on a specific. =?Utf-8?B?ZWJ1enoxMw==?= Microsoft Excel Misc 1 18th Jan 2005 05:53 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:31 PM.