| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting dates to change if its more than 3 days go
umPlease please can some one please help me i'm tyring to get a list of dates
to change if its today to 3 days old to turn green, 3 days old to 5 days old to turn yellow and over 5 days old to turn to red? Im using excel 2007 im new at this so please make it simple :). plus Is there a way of puting dates down a column with out having to drag it down? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting dates to change if its more than 3 days go
Select all cells that you want to CF. Say the first one in the
selection is A2. Format Conditional Formatting... Choose Formula Is: =TODAY()-A2<3 =(TODAY()-A2=3)*(TODAY()-A2<5) =TODAY()-A2=5 Use Add to input the 2nd and 3rd formula. Choose the appropriate format for each. HTH Kostis Vezerides On Nov 16, 3:28*am, markwmansell wrote: umPlease please can some one please help me i'm tyring to get a list of dates to change if its today to 3 days old to turn green, 3 days old to 5 days old to turn yellow and over 5 days old to turn to red? Im using excel 2007 im new at this so please make it simple :). plus Is there a way of puting dates down a column with out having to drag it down? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting dates to change if its more than 3 days
OK i did all that but it only usings the formula that is at the of the rule
list please can you tell me how i can get all 3 working at once? "vezerid" wrote: Select all cells that you want to CF. Say the first one in the selection is A2. Format Conditional Formatting... Choose Formula Is: =TODAY()-A2<3 =(TODAY()-A2=3)*(TODAY()-A2<5) =TODAY()-A2=5 Use Add to input the 2nd and 3rd formula. Choose the appropriate format for each. HTH Kostis Vezerides On Nov 16, 3:28 am, markwmansell wrote: umPlease please can some one please help me i'm tyring to get a list of dates to change if its today to 3 days old to turn green, 3 days old to 5 days old to turn yellow and over 5 days old to turn to red? Im using excel 2007 im new at this so please make it simple :). plus Is there a way of puting dates down a column with out having to drag it down? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting dates to change if its more than 3 days
When you first open the dialog box it has place for one condition. You
change the dropdown that says Cell Value Is to Formula Is. You supply the first formula. For this condition you click the Format button and in the patterns tab you choose the color green. Then you click a button that says add. This creates space for the 2nd condition. You repeat the procedure w/ the 2nd formula and 2nd format. Then you click add again and add 3rd formula and condition. HTH Kostis On Nov 16, 5:11*pm, markwmansell wrote: OK *i did all that but it only usings the formula that is at the of the rule list please can you tell me how i can get all 3 working at once? "vezerid" wrote: Select all cells that you want to CF. Say the first one in the selection is A2. Format Conditional Formatting... Choose Formula Is: =TODAY()-A2<3 =(TODAY()-A2=3)*(TODAY()-A2<5) =TODAY()-A2=5 Use Add to input the 2nd and 3rd formula. Choose the appropriate format for each. HTH Kostis Vezerides On Nov 16, 3:28 am, markwmansell wrote: umPlease please can some one please help me i'm tyring to get a list of dates to change if its today to 3 days old to turn green, 3 days old to 5 days old to turn yellow and over 5 days old to turn to red? Im using excel 2007 im new at this so please make it simple :). plus Is there a way of puting dates down a column with out having to drag it down? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting dates to change if its more than 3 days
It does not work like that for excel 2007 there is alot more options but i
have done it another way thank for your help anyway. "vezerid" wrote: When you first open the dialog box it has place for one condition. You change the dropdown that says Cell Value Is to Formula Is. You supply the first formula. For this condition you click the Format button and in the patterns tab you choose the color green. Then you click a button that says add. This creates space for the 2nd condition. You repeat the procedure w/ the 2nd formula and 2nd format. Then you click add again and add 3rd formula and condition. HTH Kostis On Nov 16, 5:11 pm, markwmansell wrote: OK i did all that but it only usings the formula that is at the of the rule list please can you tell me how i can get all 3 working at once? "vezerid" wrote: Select all cells that you want to CF. Say the first one in the selection is A2. Format Conditional Formatting... Choose Formula Is: =TODAY()-A2<3 =(TODAY()-A2=3)*(TODAY()-A2<5) =TODAY()-A2=5 Use Add to input the 2nd and 3rd formula. Choose the appropriate format for each. HTH Kostis Vezerides On Nov 16, 3:28 am, markwmansell wrote: umPlease please can some one please help me i'm tyring to get a list of dates to change if its today to 3 days old to turn green, 3 days old to 5 days old to turn yellow and over 5 days old to turn to red? Im using excel 2007 im new at this so please make it simple :). plus Is there a way of puting dates down a column with out having to drag it down? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting dates to change if its more than 3 days
Wait nope it still does not work i can do it on the old excel but i can not
do it on excel 2007 they just want work together. "markwmansell" wrote: It does not work like that for excel 2007 there is alot more options but i have done it another way thank for your help anyway. "vezerid" wrote: When you first open the dialog box it has place for one condition. You change the dropdown that says Cell Value Is to Formula Is. You supply the first formula. For this condition you click the Format button and in the patterns tab you choose the color green. Then you click a button that says add. This creates space for the 2nd condition. You repeat the procedure w/ the 2nd formula and 2nd format. Then you click add again and add 3rd formula and condition. HTH Kostis On Nov 16, 5:11 pm, markwmansell wrote: OK i did all that but it only usings the formula that is at the of the rule list please can you tell me how i can get all 3 working at once? "vezerid" wrote: Select all cells that you want to CF. Say the first one in the selection is A2. Format Conditional Formatting... Choose Formula Is: =TODAY()-A2<3 =(TODAY()-A2=3)*(TODAY()-A2<5) =TODAY()-A2=5 Use Add to input the 2nd and 3rd formula. Choose the appropriate format for each. HTH Kostis Vezerides On Nov 16, 3:28 am, markwmansell wrote: umPlease please can some one please help me i'm tyring to get a list of dates to change if its today to 3 days old to turn green, 3 days old to 5 days old to turn yellow and over 5 days old to turn to red? Im using excel 2007 im new at this so please make it simple :). plus Is there a way of puting dates down a column with out having to drag it down? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formating to highlight dates 30, 60, and 90 days out? | Excel Worksheet Functions | |||
| Conditional Formatting - Dates | Excel Discussion (Misc queries) | |||
| Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
| Conditional formatting based on a date + 30 days | Excel Discussion (Misc queries) | |||
| Help with Conditional formatting with Dates | Excel Discussion (Misc queries) | |||
Hybrid Mode
