Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Conditional Formatting Dates calculating 10 days and 30 days from a certain date


Hi there,

I have a spreadsheet as follows:

Column A Column B Column C Column D
04/09/2007 Ann Other 14/09/2007 04/10/2007
04/09/2007 Joe Bloggs
05/09/2007 Trudy Roundwindow
05/09/2007 Duncan Disorderly
10/09/2007 Gerry Cann

What I’d like to do is:

1. Use a formula or conditional formatting to make the date appear
automatically in the Column C, calculating 10 days from the date that
appears in Column A and formatted so that it appears in Red

2. Use a formula or conditional formatting to make the date appear
automatically in the Column D, calculating 30 days from the date that
appears in Column A and formatted so that it appears in Red

I know it’s something to do with Conditional Formatting and the TODAY()
function but I’m stumped as to how to do it.

Hope I've explained this sufficiently

Any solutions please?

Thanks in advance

Sioux




--
Sioux
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default Conditional Formatting Dates calculating 10 days and 30 days from a certain date

Doesn't sound to me like either conditional formatting or the TODAY()
function.

If you've got a date in A1, and in C1 you want a date 10 days on from there,
the formula is =A1+10. Similarly in D1 you want =A1+30.
If you want it in red, Format/ Cells, and then the Font tab.
--
David Biddulph

"Sioux" wrote in message
...

Hi there,

I have a spreadsheet as follows:

Column A Column B Column C Column D
04/09/2007 Ann Other 14/09/2007 04/10/2007
04/09/2007 Joe Bloggs
05/09/2007 Trudy Roundwindow
05/09/2007 Duncan Disorderly
10/09/2007 Gerry Cann

What I'd like to do is:

1. Use a formula or conditional formatting to make the date appear
automatically in the Column C, calculating 10 days from the date that
appears in Column A and formatted so that it appears in Red

2. Use a formula or conditional formatting to make the date appear
automatically in the Column D, calculating 30 days from the date that
appears in Column A and formatted so that it appears in Red

I know it's something to do with Conditional Formatting and the TODAY()
function but I'm stumped as to how to do it.

Hope I've explained this sufficiently

Any solutions please?

Thanks in advance

Sioux



  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bj bj is offline
external usenet poster
 
Posts: 1,397
Default Conditional Formatting Dates calculating 10 days and 30 days from

from your write up what you would need to to do is in c1 enter = A1+10
in D1 = A1+30
format both as red font. copy andd paste down

If you want them to only show up when something happens, we need more
information as to what triggers the show up.

"Sioux" wrote:


Hi there,

I have a spreadsheet as follows:

Column A Column B Column C Column D
04/09/2007 Ann Other 14/09/2007 04/10/2007
04/09/2007 Joe Bloggs
05/09/2007 Trudy Roundwindow
05/09/2007 Duncan Disorderly
10/09/2007 Gerry Cann

What Id like to do is:

1. Use a formula or conditional formatting to make the date appear
automatically in the Column C, calculating 10 days from the date that
appears in Column A and formatted so that it appears in Red

2. Use a formula or conditional formatting to make the date appear
automatically in the Column D, calculating 30 days from the date that
appears in Column A and formatted so that it appears in Red

I know its something to do with Conditional Formatting and the TODAY()
function but Im stumped as to how to do it.

Hope I've explained this sufficiently

Any solutions please?

Thanks in advance

Sioux




--
Sioux

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
Calculating days between dates SiH23 Excel Discussion (Misc queries) 1 October 9th 07 06:45 PM
Dates: calculating days in between Candy Excel Discussion (Misc queries) 2 August 8th 07 08:33 PM
Calculating days between two dates lledelen Excel Discussion (Misc queries) 4 March 9th 07 09:48 PM
Calculating Days Between Dates martins New Users to Excel 5 March 26th 06 11:46 PM
Conditional formatting based on a date + 30 days Laura4363 Excel Discussion (Misc queries) 5 January 13th 06 12:07 PM


All times are GMT +1. The time now is 08:46 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"