Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Need help changing one cell (red, green, yellow) based on a date range of two
other cells. If current date is (before, during or after) date range turn a certain cell a color. Thanks, Randy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Assuming dates are in A1 and B1
Select C1 and FormatCFCondition1Formula is: =B1<A1 format to a color AddCondition2Formula is: =B1=A1 format to a color Condition3 will be =B1A1 Gord Dibben MS Excel MVP On Thu, 18 Oct 2007 13:11:02 -0700, Randy wrote: Need help changing one cell (red, green, yellow) based on a date range of two other cells. If current date is (before, during or after) date range turn a certain cell a color. Thanks, Randy |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Thanks - what I'm looking for is the following:
Yes, dates are in A1 and B1 (Date Range) 1. If today's date<A1 format to a color 2. If today's date is equal to or greater than A1 and equal to or less than B1 format to a color 3. If today's dateB1 format to a color Thanks, Randy "Gord Dibben" wrote: Assuming dates are in A1 and B1 Select C1 and FormatCFCondition1Formula is: =B1<A1 format to a color AddCondition2Formula is: =B1=A1 format to a color Condition3 will be =B1A1 Gord Dibben MS Excel MVP On Thu, 18 Oct 2007 13:11:02 -0700, Randy wrote: Need help changing one cell (red, green, yellow) based on a date range of two other cells. If current date is (before, during or after) date range turn a certain cell a color. Thanks, Randy |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
CF Condition 1: Formula Is =TODAY()<A1
CF Condition 2: Formula Is =TODAY()<=B1 CF Condition 3: Formula Is =TODAY()B1 (but this could be your default colour setting) -- David Biddulph "Randy" wrote in message ... Thanks - what I'm looking for is the following: Yes, dates are in A1 and B1 (Date Range) 1. If today's date<A1 format to a color 2. If today's date is equal to or greater than A1 and equal to or less than B1 format to a color 3. If today's dateB1 format to a color Thanks, Randy "Gord Dibben" wrote: Assuming dates are in A1 and B1 Select C1 and FormatCFCondition1Formula is: =B1<A1 format to a color AddCondition2Formula is: =B1=A1 format to a color Condition3 will be =B1A1 Gord Dibben MS Excel MVP On Thu, 18 Oct 2007 13:11:02 -0700, Randy wrote: Need help changing one cell (red, green, yellow) based on a date range of two other cells. If current date is (before, during or after) date range turn a certain cell a color. Thanks, Randy |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Thanks!
I think we're getting close and maybe I'm just not getting this but: Condition 2 only works if my date is equal to or less than B1. I need Condition 2 to be: if today is equal to/less than B1 but also equal to/greater than A1 change color. Also the three conditions will have different colors. Condition 1 = Color1 Condition 2 = Color2 Condition 3 = Color3 "David Biddulph" wrote: CF Condition 1: Formula Is =TODAY()<A1 CF Condition 2: Formula Is =TODAY()<=B1 CF Condition 3: Formula Is =TODAY()B1 (but this could be your default colour setting) -- David Biddulph "Randy" wrote in message ... Thanks - what I'm looking for is the following: Yes, dates are in A1 and B1 (Date Range) 1. If today's date<A1 format to a color 2. If today's date is equal to or greater than A1 and equal to or less than B1 format to a color 3. If today's dateB1 format to a color Thanks, Randy "Gord Dibben" wrote: Assuming dates are in A1 and B1 Select C1 and FormatCFCondition1Formula is: =B1<A1 format to a color AddCondition2Formula is: =B1=A1 format to a color Condition3 will be =B1A1 Gord Dibben MS Excel MVP On Thu, 18 Oct 2007 13:11:02 -0700, Randy wrote: Need help changing one cell (red, green, yellow) based on a date range of two other cells. If current date is (before, during or after) date range turn a certain cell a color. Thanks, Randy |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Did you try it?
As far as condition 2 is concerned, you don't need the test for =A1, because if <A1 it will have satisfied condition 1, and thus not got to test 2. Similarly condition 3 isn't strictly necessary, which is why I said the default colour will do. When you insert each conditiion in CF, you can set the appropriate colour with each. -- David Biddulph "Randy" wrote in message ... Thanks! I think we're getting close and maybe I'm just not getting this but: Condition 2 only works if my date is equal to or less than B1. I need Condition 2 to be: if today is equal to/less than B1 but also equal to/greater than A1 change color. Also the three conditions will have different colors. Condition 1 = Color1 Condition 2 = Color2 Condition 3 = Color3 "David Biddulph" wrote: CF Condition 1: Formula Is =TODAY()<A1 CF Condition 2: Formula Is =TODAY()<=B1 CF Condition 3: Formula Is =TODAY()B1 (but this could be your default colour setting) -- David Biddulph "Randy" wrote in message ... Thanks - what I'm looking for is the following: Yes, dates are in A1 and B1 (Date Range) 1. If today's date<A1 format to a color 2. If today's date is equal to or greater than A1 and equal to or less than B1 format to a color 3. If today's dateB1 format to a color Thanks, Randy "Gord Dibben" wrote: Assuming dates are in A1 and B1 Select C1 and FormatCFCondition1Formula is: =B1<A1 format to a color AddCondition2Formula is: =B1=A1 format to a color Condition3 will be =B1A1 Gord Dibben MS Excel MVP On Thu, 18 Oct 2007 13:11:02 -0700, Randy wrote: Need help changing one cell (red, green, yellow) based on a date range of two other cells. If current date is (before, during or after) date range turn a certain cell a color. Thanks, Randy |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
Sometimes you should just stop asking questions and just do
it..........Thanks! It worked. Regards, Randy "David Biddulph" wrote: Did you try it? As far as condition 2 is concerned, you don't need the test for =A1, because if <A1 it will have satisfied condition 1, and thus not got to test 2. Similarly condition 3 isn't strictly necessary, which is why I said the default colour will do. When you insert each conditiion in CF, you can set the appropriate colour with each. -- David Biddulph "Randy" wrote in message ... Thanks! I think we're getting close and maybe I'm just not getting this but: Condition 2 only works if my date is equal to or less than B1. I need Condition 2 to be: if today is equal to/less than B1 but also equal to/greater than A1 change color. Also the three conditions will have different colors. Condition 1 = Color1 Condition 2 = Color2 Condition 3 = Color3 "David Biddulph" wrote: CF Condition 1: Formula Is =TODAY()<A1 CF Condition 2: Formula Is =TODAY()<=B1 CF Condition 3: Formula Is =TODAY()B1 (but this could be your default colour setting) -- David Biddulph "Randy" wrote in message ... Thanks - what I'm looking for is the following: Yes, dates are in A1 and B1 (Date Range) 1. If today's date<A1 format to a color 2. If today's date is equal to or greater than A1 and equal to or less than B1 format to a color 3. If today's dateB1 format to a color Thanks, Randy "Gord Dibben" wrote: Assuming dates are in A1 and B1 Select C1 and FormatCFCondition1Formula is: =B1<A1 format to a color AddCondition2Formula is: =B1=A1 format to a color Condition3 will be =B1A1 Gord Dibben MS Excel MVP On Thu, 18 Oct 2007 13:11:02 -0700, Randy wrote: Need help changing one cell (red, green, yellow) based on a date range of two other cells. If current date is (before, during or after) date range turn a certain cell a color. Thanks, Randy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional formatting ? | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |