Date formula
 

I need a formula to change to red on a blank cell or a date that is older
than one month from the present date. I am not a techi so please be patient
& step by step with me. Desparately awaiting an answer.
J

Date formula
 

Select the cells where you want your formatting...
Let us assume A1:A20
Click on Format-Conditional Formatting
In Condition 1
Cell Value IS Equal To ="" and pick your formatting

Condition 2
Formula is =(A1-30)<TODAY() and pick your formatting

"J" wrote:

I need a formula to change to red on a blank cell or a date that is older
than one month from the present date. I am not a techi so please be patient
& step by step with me. Desparately awaiting an answer.
J

Date formula
 

Thank you for your response but now I'm faced with another delima. Here is
whatI have:
I have a date in a cell, I need for that date to turn red if it is blank or
if the date is prior to 01-Sep-2008. Awaiting your response.

"Sheeloo" wrote:

Select the cells where you want your formatting...
Let us assume A1:A20
Click on Format-Conditional Formatting
In Condition 1
Cell Value IS Equal To ="" and pick your formatting

Condition 2
Formula is =(A1-30)<TODAY() and pick your formatting

"J" wrote:

I need a formula to change to red on a blank cell or a date that is older
than one month from the present date. I am not a techi so please be patient
& step by step with me. Desparately awaiting an answer.
J

Date formula
 

First condition would be same
For second use
=A1<DATE(2008,9,1)

"J" wrote:

Thank you for your response but now I'm faced with another delima. Here is
whatI have:
I have a date in a cell, I need for that date to turn red if it is blank or
if the date is prior to 01-Sep-2008. Awaiting your response.

"Sheeloo" wrote:

Select the cells where you want your formatting...
Let us assume A1:A20
Click on Format-Conditional Formatting
In Condition 1
Cell Value IS Equal To ="" and pick your formatting

Condition 2
Formula is =(A1-30)<TODAY() and pick your formatting

"J" wrote:

I need a formula to change to red on a blank cell or a date that is older
than one month from the present date. I am not a techi so please be patient
& step by step with me. Desparately awaiting an answer.
J

Date formula
 

Please don't go Im tring this now

"Sheeloo" wrote:

First condition would be same
For second use
=A1<DATE(2008,9,1)

"J" wrote:

Thank you for your response but now I'm faced with another delima. Here is
whatI have:
I have a date in a cell, I need for that date to turn red if it is blank or
if the date is prior to 01-Sep-2008. Awaiting your response.

"Sheeloo" wrote:

Select the cells where you want your formatting...
Let us assume A1:A20
Click on Format-Conditional Formatting
In Condition 1
Cell Value IS Equal To ="" and pick your formatting

Condition 2
Formula is =(A1-30)<TODAY() and pick your formatting

"J" wrote:

I need a formula to change to red on a blank cell or a date that is older
than one month from the present date. I am not a techi so please be patient
& step by step with me. Desparately awaiting an answer.
J

Date formula
 

:-)

"J" wrote:

Please don't go Im tring this now

Date formula
 

It did the blank cell but not the cells with dates priouv to 01-Sep-2008.
Does it matter what format I have the dates appear or typed in. It is typed
in as "9/1/08" however it appears as 01-Sep-2008.

"J" wrote:

Please don't go Im tring this now

"Sheeloo" wrote:

First condition would be same
For second use
=A1<DATE(2008,9,1)

"J" wrote:

Thank you for your response but now I'm faced with another delima. Here is
whatI have:
I have a date in a cell, I need for that date to turn red if it is blank or
if the date is prior to 01-Sep-2008. Awaiting your response.

"Sheeloo" wrote:

Select the cells where you want your formatting...
Let us assume A1:A20
Click on Format-Conditional Formatting
In Condition 1
Cell Value IS Equal To ="" and pick your formatting

Condition 2
Formula is =(A1-30)<TODAY() and pick your formatting

"J" wrote:

I need a formula to change to red on a blank cell or a date that is older
than one month from the present date. I am not a techi so please be patient
& step by step with me. Desparately awaiting an answer.
J

Date formula
 

it does not matter.
try with 8/31/08

condition is less than 9/1 so ....
"J" wrote:

It did the blank cell but not the cells with dates priouv to 01-Sep-2008.
Does it matter what format I have the dates appear or typed in. It is typed
in as "9/1/08" however it appears as 01-Sep-2008.

"J" wrote:

Please don't go Im tring this now

"Sheeloo" wrote:

First condition would be same
For second use
=A1<DATE(2008,9,1)

"J" wrote:

Thank you for your response but now I'm faced with another delima. Here is
whatI have:
I have a date in a cell, I need for that date to turn red if it is blank or
if the date is prior to 01-Sep-2008. Awaiting your response.

"Sheeloo" wrote:

Select the cells where you want your formatting...
Let us assume A1:A20
Click on Format-Conditional Formatting
In Condition 1
Cell Value IS Equal To ="" and pick your formatting

Condition 2
Formula is =(A1-30)<TODAY() and pick your formatting

"J" wrote:

I need a formula to change to red on a blank cell or a date that is older
than one month from the present date. I am not a techi so please be patient
& step by step with me. Desparately awaiting an answer.
J

Date formula
 

You were right. After @ long days of trying to find this formula you have
saved my life/job. THANK YOU So much. How do I post a rate on this? I tried
and can't get it.

"Sheeloo" wrote:


it does not matter.
try with 8/31/08

condition is less than 9/1 so ....
"J" wrote:

It did the blank cell but not the cells with dates priouv to 01-Sep-2008.
Does it matter what format I have the dates appear or typed in. It is typed
in as "9/1/08" however it appears as 01-Sep-2008.

"J" wrote:

Please don't go Im tring this now

"Sheeloo" wrote:

First condition would be same
For second use
=A1<DATE(2008,9,1)

"J" wrote:

Thank you for your response but now I'm faced with another delima. Here is
whatI have:
I have a date in a cell, I need for that date to turn red if it is blank or
if the date is prior to 01-Sep-2008. Awaiting your response.

"Sheeloo" wrote:

Select the cells where you want your formatting...
Let us assume A1:A20
Click on Format-Conditional Formatting
In Condition 1
Cell Value IS Equal To ="" and pick your formatting

Condition 2
Formula is =(A1-30)<TODAY() and pick your formatting

"J" wrote:

I need a formula to change to red on a blank cell or a date that is older
than one month from the present date. I am not a techi so please be patient
& step by step with me. Desparately awaiting an answer.
J

Date formula
 

Glad I could help.

I don't think there is any rating - you can just mark whether post was
helpful or not...

It is no big deal... I happened to know something you needed...

If you had searched (here or on the internet) you might have found the
answer yourself.

Have a nice day/night...

"J" wrote:

You were right. After @ long days of trying to find this formula you have
saved my life/job. THANK YOU So much. How do I post a rate on this? I tried
and can't get it.

Date formula
 

You just don't know I can now go to work tomorrow and sow my boss that I
figured it out without his help. You literally help me in a million ways.
It's night here in California where are you at?

"Sheeloo" wrote:

Glad I could help.

I don't think there is any rating - you can just mark whether post was
helpful or not...

It is no big deal... I happened to know something you needed...

If you had searched (here or on the internet) you might have found the
answer yourself.

Have a nice day/night...

"J" wrote:

You were right. After @ long days of trying to find this formula you have
saved my life/job. THANK YOU So much. How do I post a rate on this? I tried
and can't get it.

Date formula
 

Me too - San Jose area...

You can send an email if you need help in future... Just remove the first
part after my email id given here...

I am delighted that I could help you score points with your boss.... ;-)

"J" wrote:

You just don't know I can now go to work tomorrow and sow my boss that I
figured it out without his help. You literally help me in a million ways.
It's night here in California where are you at?

"Sheeloo" wrote:

Glad I could help.

I don't think there is any rating - you can just mark whether post was
helpful or not...

It is no big deal... I happened to know something you needed...

If you had searched (here or on the internet) you might have found the
answer yourself.

Have a nice day/night...

"J" wrote:

You were right. After @ long days of trying to find this formula you have
saved my life/job. THANK YOU So much. How do I post a rate on this? I tried
and can't get it.

Date formula
 

I have a need for this same type of formula, except, I need it to highlight
cells that are over 6 months old. I tryed changing the formula to
=(A1-180)<TODAY() and it highlights all cells that have a date in them. Even
if the date was yesterday. What am I doing wrong?
--
Thanks,
RRS


"Sheeloo" wrote:

Select the cells where you want your formatting...
Let us assume A1:A20
Click on Format-Conditional Formatting
In Condition 1
Cell Value IS Equal To ="" and pick your formatting

Condition 2
Formula is =(A1-30)<TODAY() and pick your formatting

"J" wrote:

I need a formula to change to red on a blank cell or a date that is older
than one month from the present date. I am not a techi so please be patient
& step by step with me. Desparately awaiting an answer.
J

Date formula
 

What's in A1?

Make sure it's a real date.

RRS wrote:

I have a need for this same type of formula, except, I need it to highlight
cells that are over 6 months old. I tryed changing the formula to
=(A1-180)<TODAY() and it highlights all cells that have a date in them. Even
if the date was yesterday. What am I doing wrong?
--
Thanks,
RRS

"Sheeloo" wrote:

Select the cells where you want your formatting...
Let us assume A1:A20
Click on Format-Conditional Formatting
In Condition 1
Cell Value IS Equal To ="" and pick your formatting

Condition 2
Formula is =(A1-30)<TODAY() and pick your formatting

"J" wrote:

I need a formula to change to red on a blank cell or a date that is older
than one month from the present date. I am not a techi so please be patient
& step by step with me. Desparately awaiting an answer.
J

--

Dave Peterson

Date formula
 

3/5/2010, The whole column is formated to this type of date.
--
Thanks,
RRS


"Dave Peterson" wrote:

What's in A1?

Make sure it's a real date.

RRS wrote:

I have a need for this same type of formula, except, I need it to highlight
cells that are over 6 months old. I tryed changing the formula to
=(A1-180)<TODAY() and it highlights all cells that have a date in them. Even
if the date was yesterday. What am I doing wrong?
--
Thanks,
RRS

"Sheeloo" wrote:

Select the cells where you want your formatting...
Let us assume A1:A20
Click on Format-Conditional Formatting
In Condition 1
Cell Value IS Equal To ="" and pick your formatting

Condition 2
Formula is =(A1-30)<TODAY() and pick your formatting

"J" wrote:

I need a formula to change to red on a blank cell or a date that is older
than one month from the present date. I am not a techi so please be patient
& step by step with me. Desparately awaiting an answer.
J

--

Dave Peterson
.

Date formula
 

Maybe you want:
=(a1+180)<today()



RRS wrote:

3/5/2010, The whole column is formated to this type of date.
--
Thanks,
RRS

"Dave Peterson" wrote:

What's in A1?

Make sure it's a real date.

RRS wrote:

I have a need for this same type of formula, except, I need it to highlight
cells that are over 6 months old. I tryed changing the formula to
=(A1-180)<TODAY() and it highlights all cells that have a date in them. Even
if the date was yesterday. What am I doing wrong?
--
Thanks,
RRS

"Sheeloo" wrote:

Select the cells where you want your formatting...
Let us assume A1:A20
Click on Format-Conditional Formatting
In Condition 1
Cell Value IS Equal To ="" and pick your formatting

Condition 2
Formula is =(A1-30)<TODAY() and pick your formatting

"J" wrote:

I need a formula to change to red on a blank cell or a date that is older
than one month from the present date. I am not a techi so please be patient
& step by step with me. Desparately awaiting an answer.
J

--

Dave Peterson
.


--

Dave Peterson

Date formula
 

This works for me.

=A1<TODAY()-180


Gord Dibben MS Excel MVP

On Mon, 24 May 2010 07:24:01 -0700, RRS
wrote:

I have a need for this same type of formula, except, I need it to highlight
cells that are over 6 months old. I tryed changing the formula to
=(A1-180)<TODAY() and it highlights all cells that have a date in them. Even
if the date was yesterday. What am I doing wrong?