| 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
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 |
|
#9
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 |
|
#10
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 . |
|
#11
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 |
|
#12
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) | |||
Hybrid Mode
