Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
I am having trouble using conditional formatting when comparing two dates.
What I need is. Cell A1 has a date 02/01/2007 Cell A2 has a date 03/05/2008 I want cell A2 Highlighted Red if the difference between the dates is 395 days or more. I'm a novice in excel and any help is appreciated. Thank you, -- John Johansen |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
Hi,
go to conditional formating, and use where the formula is A2-A1395, options fill with red color "John Johansen" wrote: I am having trouble using conditional formatting when comparing two dates. What I need is. Cell A1 has a date 02/01/2007 Cell A2 has a date 03/05/2008 I want cell A2 Highlighted Red if the difference between the dates is 395 days or more. I'm a novice in excel and any help is appreciated. Thank you, -- John Johansen |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
Hello,
I've tried that and it doesn't work. I'm not sure why because if I goto a different cell and enter the formula =IF((A2-A1)395,"NC","C") it returns either an NC or C like you would expect but for some reason it doesn't evaluate correctly in conditional formatting. -- John Johansen "Eduardo" wrote: Hi, go to conditional formating, and use where the formula is A2-A1395, options fill with red color "John Johansen" wrote: I am having trouble using conditional formatting when comparing two dates. What I need is. Cell A1 has a date 02/01/2007 Cell A2 has a date 03/05/2008 I want cell A2 Highlighted Red if the difference between the dates is 395 days or more. I'm a novice in excel and any help is appreciated. Thank you, -- John Johansen |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
John use the formula that Eduardo suggests but type an = in front. it worked
for me when i did this -- Eric "John Johansen" wrote: Hello, I've tried that and it doesn't work. I'm not sure why because if I goto a different cell and enter the formula =IF((A2-A1)395,"NC","C") it returns either an NC or C like you would expect but for some reason it doesn't evaluate correctly in conditional formatting. -- John Johansen "Eduardo" wrote: Hi, go to conditional formating, and use where the formula is A2-A1395, options fill with red color "John Johansen" wrote: I am having trouble using conditional formatting when comparing two dates. What I need is. Cell A1 has a date 02/01/2007 Cell A2 has a date 03/05/2008 I want cell A2 Highlighted Red if the difference between the dates is 395 days or more. I'm a novice in excel and any help is appreciated. Thank you, -- John Johansen |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
Select cell A2
Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =A2-A1395 Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "John Johansen" wrote in message ... Hello, I've tried that and it doesn't work. I'm not sure why because if I goto a different cell and enter the formula =IF((A2-A1)395,"NC","C") it returns either an NC or C like you would expect but for some reason it doesn't evaluate correctly in conditional formatting. -- John Johansen "Eduardo" wrote: Hi, go to conditional formating, and use where the formula is A2-A1395, options fill with red color "John Johansen" wrote: I am having trouble using conditional formatting when comparing two dates. What I need is. Cell A1 has a date 02/01/2007 Cell A2 has a date 03/05/2008 I want cell A2 Highlighted Red if the difference between the dates is 395 days or more. I'm a novice in excel and any help is appreciated. Thank you, -- John Johansen |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
That did it thank you both
-- John Johansen "John Johansen" wrote: Hello, I've tried that and it doesn't work. I'm not sure why because if I goto a different cell and enter the formula =IF((A2-A1)395,"NC","C") it returns either an NC or C like you would expect but for some reason it doesn't evaluate correctly in conditional formatting. -- John Johansen "Eduardo" wrote: Hi, go to conditional formating, and use where the formula is A2-A1395, options fill with red color "John Johansen" wrote: I am having trouble using conditional formatting when comparing two dates. What I need is. Cell A1 has a date 02/01/2007 Cell A2 has a date 03/05/2008 I want cell A2 Highlighted Red if the difference between the dates is 395 days or more. I'm a novice in excel and any help is appreciated. Thank you, -- John Johansen |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
Thank you Eric, I miissed the =
"Eric D" wrote: John use the formula that Eduardo suggests but type an = in front. it worked for me when i did this -- Eric "John Johansen" wrote: Hello, I've tried that and it doesn't work. I'm not sure why because if I goto a different cell and enter the formula =IF((A2-A1)395,"NC","C") it returns either an NC or C like you would expect but for some reason it doesn't evaluate correctly in conditional formatting. -- John Johansen "Eduardo" wrote: Hi, go to conditional formating, and use where the formula is A2-A1395, options fill with red color "John Johansen" wrote: I am having trouble using conditional formatting when comparing two dates. What I need is. Cell A1 has a date 02/01/2007 Cell A2 has a date 03/05/2008 I want cell A2 Highlighted Red if the difference between the dates is 395 days or more. I'm a novice in excel and any help is appreciated. Thank you, -- John Johansen |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |