#1   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 13
Default Due Date

it is possible to see in excel sheet
for excample.

10/10/2007
15/11/2007
28/09/2007
30/04/2008
06/12/2007
18/08/2009

the above dates i want to see befor due for 30 days to change
difference colour or any other,
it is possible

please help me

Best Regards
Anshad
  #2   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 473
Default Due Date

If I understand you, you want to change the colour of cells containing
dates that are within 30 days of the current date.

Select the cells
Format Conditional Formatting Cell value is between =TODAY() and
=TODAY()+30 Format Patterns yellow (or whatever you prefer)

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

  #3   Report Post  
Posted to microsoft.public.excel.links
external usenet poster
 
Posts: 2,344
Default Due Date

Hi,

Let's say you want the cells to change to red when the current date is 5
days before the due date, which is the value in the cell. Or maybe you want
the cell to change color when the account is 30 or more days past due, the
date in the cell.

In the second case:
1. Select the cells and choose Format, Conditional Formatting,
2. from the first drop down choose Formula is and in the second box enter
the formula
=A1=TODAY()+30
where A1 is the first cell with dates.
3. click Format and choose a color on the Patterns tab, click OK twice.

--
Thanks,
Shane Devenshire


" wrote:

it is possible to see in excel sheet
for excample.

10/10/2007
15/11/2007
28/09/2007
30/04/2008
06/12/2007
18/08/2009

the above dates i want to see befor due for 30 days to change
difference colour or any other,
it is possible

please help me

Best Regards
Anshad

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Making a date go red, if date passes todays date. Jamie Excel Worksheet Functions 2 September 9th 08 02:14 PM
how to get the random date between the start date and the end date? Sebation Excel Worksheet Functions 3 October 13th 07 12:20 PM
Report Date - Date Recv = Days Late, but how to rid completed date MS Questionnairess Excel Worksheet Functions 1 January 25th 07 12:05 AM
Formula for determining if two date columns fall within specific date range Igottabeme Excel Discussion (Misc queries) 1 April 20th 06 10:03 PM
Date updates from worksheet to chart & changes date to a date series! Help!! Jayjg Charts and Charting in Excel 2 January 22nd 05 04:00 PM


All times are GMT +1. The time now is 06:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"