Projected dates left to right drom D5:N5

Actual dates are entered one at a time below projected date as a project
ends in D6:N6

The answer goes in D7:N7

All works fine.

1. If Todays date exceeds Projected date =1 day
ie: Expected 2/11/09 and Today is 2/12/09

2. I'd like to turn "That Cell" in D6:N6 Blue, (not all cells,) just the
Cell that exceeds the date based on Today. =1

3. When a date IS entered into a BLUE D6 rows cell, I would like the cell to
look normal, turn the BLUE OFF and show the date entered.


Can this be done?

Select D6:N6 and enter this formula in CF formula field, choose blue pattern!
If you enter a new date in D6 that is <=TODAY(), blue will be switched off.
If you want to switch off blue at ANY new date then it can be done only via a
VBA event sub.

=TODAY()-D6=1

Regards,
Stefi

€žMark€� ezt Ã*rta:

Projected dates left to right drom D5:N5

Actual dates are entered one at a time below projected date as a project
ends in D6:N6

The answer goes in D7:N7

All works fine.

1. If Todays date exceeds Projected date =1 day
ie: Expected 2/11/09 and Today is 2/12/09

2. I'd like to turn "That Cell" in D6:N6 Blue, (not all cells,) just the
Cell that exceeds the date based on Today. =1

3. When a date IS entered into a BLUE D6 rows cell, I would like the cell to
look normal, turn the BLUE OFF and show the date entered.


Can this be done?

You could select all the cells that need this conditional formatting and in
the conditional formatting dialog use: Formula Is =D6-TODAY()=1 and set
required format
I have used D6 here as I assume this in the first cell in the selected range
However, is any cell has a value grater than about 39800 then it could be
mistaken for a date
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mark" wrote in message
...
Projected dates left to right drom D5:N5

Actual dates are entered one at a time below projected date as a project
ends in D6:N6

The answer goes in D7:N7

All works fine.

1. If Todays date exceeds Projected date =1 day
ie: Expected 2/11/09 and Today is 2/12/09

2. I'd like to turn "That Cell" in D6:N6 Blue, (not all cells,) just the
Cell that exceeds the date based on Today. =1

3. When a date IS entered into a BLUE D6 rows cell, I would like the cell
to
look normal, turn the BLUE OFF and show the date entered.


Can this be done?

Thanks Stefi,

I will give it a try,


Don't understand the VBA staement, I'm a newbie!

Can this CF Be included (added to) under a full sheet that has formulas,
without changeing current text/date /headings.

Or does it appear, I just start his new CF at the next new line?

"Stefi" wrote:

Select D6:N6 and enter this formula in CF formula field, choose blue pattern!
If you enter a new date in D6 that is <=TODAY(), blue will be switched off.
If you want to switch off blue at ANY new date then it can be done only via a
VBA event sub.

=TODAY()-D6=1

Regards,
Stefi

€žMark€� ezt Ã*rta:

Projected dates left to right drom D5:N5

Actual dates are entered one at a time below projected date as a project
ends in D6:N6

The answer goes in D7:N7

All works fine.

1. If Todays date exceeds Projected date =1 day
ie: Expected 2/11/09 and Today is 2/12/09

2. I'd like to turn "That Cell" in D6:N6 Blue, (not all cells,) just the
Cell that exceeds the date based on Today. =1

3. When a date IS entered into a BLUE D6 rows cell, I would like the cell to
look normal, turn the BLUE OFF and show the date entered.


Can this be done?

No, I entered a test date which poulated D5:N5

D6 now is 4/25/09 and dates gets higher to the right)
However D6:N6 are all blue.

I would like the cells to remain plain and only to turn BLUE, if the
coorsponding date above D6:N6, exceeds the date above in D5:N5 =1 from
todays date

I'm sure I didn't say it right.

Thank you for your quick response.

Mark

"Stefi" wrote:

Select D6:N6 and enter this formula in CF formula field, choose blue pattern!
If you enter a new date in D6 that is <=TODAY(), blue will be switched off.
If you want to switch off blue at ANY new date then it can be done only via a
VBA event sub.

=TODAY()-D6=1

Regards,
Stefi

€žMark€� ezt Ã*rta:

Projected dates left to right drom D5:N5

Actual dates are entered one at a time below projected date as a project
ends in D6:N6

The answer goes in D7:N7

All works fine.

1. If Todays date exceeds Projected date =1 day
ie: Expected 2/11/09 and Today is 2/12/09

2. I'd like to turn "That Cell" in D6:N6 Blue, (not all cells,) just the
Cell that exceeds the date based on Today. =1

3. When a date IS entered into a BLUE D6 rows cell, I would like the cell to
look normal, turn the BLUE OFF and show the date entered.


Can this be done?

Bernard,

I covered D6:N6

enterd cf
=D6-TODAY()=1

Populated dates across D5:N5

D5 = 2/7/09 Being that today is 2/9/09
D6 did not change to blue

Any ideas?

Thank you for oferring your time and expertise

"Bernard Liengme" wrote:

You could select all the cells that need this conditional formatting and in
the conditional formatting dialog use: Formula Is =D6-TODAY()=1 and set
required format
I have used D6 here as I assume this in the first cell in the selected range
However, is any cell has a value grater than about 39800 then it could be
mistaken for a date
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mark" wrote in message
...
Projected dates left to right drom D5:N5

Actual dates are entered one at a time below projected date as a project
ends in D6:N6

The answer goes in D7:N7

All works fine.

1. If Todays date exceeds Projected date =1 day
ie: Expected 2/11/09 and Today is 2/12/09

2. I'd like to turn "That Cell" in D6:N6 Blue, (not all cells,) just the
Cell that exceeds the date based on Today. =1

3. When a date IS entered into a BLUE D6 rows cell, I would like the cell
to
look normal, turn the BLUE OFF and show the date entered.


Can this be done?

Did you enter =D6-TODAY()=1
in the conditional formatting cell?
Send me a file (remove TRUENORTH.)
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mark" wrote in message
...
Bernard,

I covered D6:N6

enterd cf
=D6-TODAY()=1

Populated dates across D5:N5

D5 = 2/7/09 Being that today is 2/9/09
D6 did not change to blue

Any ideas?

Thank you for oferring your time and expertise

"Bernard Liengme" wrote:

You could select all the cells that need this conditional formatting and
in
the conditional formatting dialog use: Formula Is =D6-TODAY()=1 and set
required format
I have used D6 here as I assume this in the first cell in the selected
range
However, is any cell has a value grater than about 39800 then it could be
mistaken for a date
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mark" wrote in message
...
Projected dates left to right drom D5:N5

Actual dates are entered one at a time below projected date as a
project
ends in D6:N6

The answer goes in D7:N7

All works fine.

1. If Todays date exceeds Projected date =1 day
ie: Expected 2/11/09 and Today is 2/12/09

2. I'd like to turn "That Cell" in D6:N6 Blue, (not all cells,) just
the
Cell that exceeds the date based on Today. =1

3. When a date IS entered into a BLUE D6 rows cell, I would like the
cell
to
look normal, turn the BLUE OFF and show the date entered.


Can this be done?

Hi,

Why don't you show us some sample data and explain with that what you want
to have happen?

You say the "answer" goes into D7:N7, the answer to what, and what does that
have to do with you process.

You have and Expected Date and a Projected Date what is the difference and
where are they located?

A final point, eventually, when its all clear your formula will look
something like
=TODAY()D5

You should be highlighting row 6 when you do this.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Mark" wrote:

Bernard,

I covered D6:N6

enterd cf
=D6-TODAY()=1

Populated dates across D5:N5

D5 = 2/7/09 Being that today is 2/9/09
D6 did not change to blue

Any ideas?

Thank you for oferring your time and expertise

"Bernard Liengme" wrote:

You could select all the cells that need this conditional formatting and in
the conditional formatting dialog use: Formula Is =D6-TODAY()=1 and set
required format
I have used D6 here as I assume this in the first cell in the selected range
However, is any cell has a value grater than about 39800 then it could be
mistaken for a date
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mark" wrote in message
...
Projected dates left to right drom D5:N5

Actual dates are entered one at a time below projected date as a project
ends in D6:N6

The answer goes in D7:N7

All works fine.

1. If Todays date exceeds Projected date =1 day
ie: Expected 2/11/09 and Today is 2/12/09

2. I'd like to turn "That Cell" in D6:N6 Blue, (not all cells,) just the
Cell that exceeds the date based on Today. =1

3. When a date IS entered into a BLUE D6 rows cell, I would like the cell
to
look normal, turn the BLUE OFF and show the date entered.


Can this be done?

No Wonder you are an MVP....

What you did was spectacular.....

Thank you...
mark

"Bernard Liengme" wrote:

Did you enter =D6-TODAY()=1
in the conditional formatting cell?
Send me a file (remove TRUENORTH.)
best wishes

--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mark" wrote in message
...
Bernard,

I covered D6:N6

enterd cf
=D6-TODAY()=1

Populated dates across D5:N5

D5 = 2/7/09 Being that today is 2/9/09
D6 did not change to blue

Any ideas?

Thank you for oferring your time and expertise

"Bernard Liengme" wrote:

You could select all the cells that need this conditional formatting and
in
the conditional formatting dialog use: Formula Is =D6-TODAY()=1 and set
required format
I have used D6 here as I assume this in the first cell in the selected
range
However, is any cell has a value grater than about 39800 then it could be
mistaken for a date
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mark" wrote in message
...
Projected dates left to right drom D5:N5

Actual dates are entered one at a time below projected date as a
project
ends in D6:N6

The answer goes in D7:N7

All works fine.

1. If Todays date exceeds Projected date =1 day
ie: Expected 2/11/09 and Today is 2/12/09

2. I'd like to turn "That Cell" in D6:N6 Blue, (not all cells,) just
the
Cell that exceeds the date based on Today. =1

3. When a date IS entered into a BLUE D6 rows cell, I would like the
cell
to
look normal, turn the BLUE OFF and show the date entered.


Can this be done?

Thanks Shane.. My superfulous explainations, are because I feel I'm
describing something for a blind person, because I am an amatuer.

When ..If I just state the obvious, usually, I get exactly what I need.
It did turn out to be( for me ) a set of advanced CF's

Bernard, hit them SPOT on.

Mark

And I Thank you for taking your time to deal with guys like me..

"Shane Devenshire" wrote:

Hi,

Why don't you show us some sample data and explain with that what you want
to have happen?

You say the "answer" goes into D7:N7, the answer to what, and what does that
have to do with you process.

You have and Expected Date and a Projected Date what is the difference and
where are they located?

A final point, eventually, when its all clear your formula will look
something like
=TODAY()D5

You should be highlighting row 6 when you do this.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Mark" wrote:

Bernard,

I covered D6:N6

enterd cf
=D6-TODAY()=1

Populated dates across D5:N5

D5 = 2/7/09 Being that today is 2/9/09
D6 did not change to blue

Any ideas?

Thank you for oferring your time and expertise

"Bernard Liengme" wrote:

You could select all the cells that need this conditional formatting and in
the conditional formatting dialog use: Formula Is =D6-TODAY()=1 and set
required format
I have used D6 here as I assume this in the first cell in the selected range
However, is any cell has a value grater than about 39800 then it could be
mistaken for a date
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Mark" wrote in message
...
Projected dates left to right drom D5:N5

Actual dates are entered one at a time below projected date as a project
ends in D6:N6

The answer goes in D7:N7

All works fine.

1. If Todays date exceeds Projected date =1 day
ie: Expected 2/11/09 and Today is 2/12/09

2. I'd like to turn "That Cell" in D6:N6 Blue, (not all cells,) just the
Cell that exceeds the date based on Today. =1

3. When a date IS entered into a BLUE D6 rows cell, I would like the cell
to
look normal, turn the BLUE OFF and show the date entered.


Can this be done?