PC Review


Reply
Thread Tools Rate Thread

Conditional Formatting-1 week

 
 
Frank
Guest
Posts: n/a
 
      11th Feb 2010
I have a spreadsheet and in cell B2 is the date the project was created i.e
Feb/10/2010. I then have a column of blank cells that require a date entry.
I need a formula to turn the range of blank cells red if no date has been
entered after 7 days from the creation date.

Any advise??
 
Reply With Quote
 
 
 
 
MarkusSchaber
Guest
Posts: n/a
 
      11th Feb 2010
Hi, Frank,

On 11 Feb., 04:05, Frank <Fr...@discussions.microsoft.com> wrote:
> I have a spreadsheet and in cell B2 is the date the project was created i..e
> Feb/10/2010. *I then have a column of blank cells that require a date entry. *
> I need a formula to turn the range of blank cells red if no date has been
> entered after 7 days from the creation date.
>
> Any advise??


Yes. The likelyhood of getting a helpful answer will drastically
increase once you post your question in a group where it is on topic.
 
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 Formatting - Highlighting the current week jfjunior Windows XP 0 22nd Apr 2008 01:56 AM
Conditional formatting: red text for appts in coming week. =?Utf-8?B?TkNfU3Vl?= Microsoft Access Reports 3 3rd Jan 2007 01:58 PM
Conditional Formatting No Longer Conditional in 2007 Beta =?Utf-8?B?Q2FjdHVhci1Oby1KdXRzdQ==?= Microsoft Excel Crashes 0 17th Nov 2006 10:01 PM
How do I do a complex conditional in a conditional formatting formula Ray Stevens Microsoft Excel Discussion 7 12th Mar 2006 10:24 PM
Conditional Formatting that will display conditional data =?Utf-8?B?QnJhaW5GYXJ0?= Microsoft Excel Worksheet Functions 1 13th Sep 2005 05:45 PM


Features
 

Advertising
 

Newsgroups
 


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