| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date formula
:-)
"J" wrote: Please don't go Im tring this now |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#12
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#13
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#14
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#15
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 . |
|
#16
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#17
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
| Excel Formula to calulate number of days passed from date to date | Excel Discussion (Misc queries) | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
| Date formula: return Quarter and Fiscal Year of a date | Excel Discussion (Misc queries) | |||
Linear Mode
