| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dates changing colors
I have read the threads concerning the dates, however, I just can't seem to
make it work. I have one column of dates that I want to change when the date is first 60 and then 30 days out. Can someone help me? -- JAS |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dates changing colors
Formula is
=$F$3TODAY()+90 add =$F$3TODAY()+60 -- Don Guillett Microsoft MVP Excel SalesAid Software "JAS" wrote in message ... I have read the threads concerning the dates, however, I just can't seem to make it work. I have one column of dates that I want to change when the date is first 60 and then 30 days out. Can someone help me? -- JAS |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dates changing colors
Something like this will test eg a due date against a defined date range (for
aging purposes). To check A2 (it must contain a real date) whether it is more than 30 days old but less than or equal to 60 days, use this in your CF, "Formula is:" : =AND(TODAY()-A230,TODAY()-A2<=60) Modify to suit your actual criteria Success? Celebrate it, hit YES below -- Max Singapore --- "JAS" wrote: I have read the threads concerning the dates, however, I just can't seem to make it work. I have one column of dates that I want to change when the date is first 60 and then 30 days out. Can someone help me? -- JAS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing colors | Excel Discussion (Misc queries) | |||
| Changing cell colors to correspond to different dates | Excel Worksheet Functions | |||
| Changing colors? | Excel Discussion (Misc queries) | |||
| Changing the colors | Excel Discussion (Misc queries) | |||
| Changing colors | Charts and Charting in Excel | |||
Linear Mode
