PC Review


Reply
Thread Tools Rate Thread

Conditional Formating For Expired Dates

 
 
=?Utf-8?B?UHJvaG9jaw==?=
Guest
Posts: n/a
 
      8th Nov 2006
I have a column of dates, I would like to have the cell turn color when the
date in the cell is older than the current date. Is there a way that this can
be done? This would easyly allow me to identify all past due accounts.


 
Reply With Quote
 
 
 
 
=?Utf-8?B?VG9tIE9naWx2eQ==?=
Guest
Posts: n/a
 
      8th Nov 2006
select your data and do Format=>Conditional Formatting

see help on conditional formatting and also


Debra Dalgleish
http://www.contextures.com/tiptech.html

look under C for conditional formatting.

--
Regards,
Tom Ogilvy



"Prohock" wrote:

> I have a column of dates, I would like to have the cell turn color when the
> date in the cell is older than the current date. Is there a way that this can
> be done? This would easyly allow me to identify all past due accounts.
>
>

 
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
Conditional formating dates Teeny Microsoft Excel Worksheet Functions 2 13th May 2010 04:13 PM
Conditional formatting with expired dates after current Josh Microsoft Excel Worksheet Functions 1 13th Apr 2010 04:37 AM
conditional formating dates, please help me mike Microsoft Excel Misc 1 9th Jan 2010 03:21 PM
Install dates formating using conditional formating? Jerry Eggleston Microsoft Excel Misc 2 9th Nov 2005 05:49 PM
CONDITIONAL FORMATING DATES =?Utf-8?B?dG9ta2xlbQ==?= Microsoft Excel Misc 3 7th Oct 2005 04:24 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:30 AM.