| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
past cell by date
ok thanks for my last post
what if i want to put a date in colum 1 and when its the value in column 2 past ie 36 months past that date i want the date cell to turn red Thanks Tony |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
past cell by date
Use Format | Conditonal Formatting with a formula of:
=A1B1+3*365 assuming that the cell you want to change is A1. Hope this helps. Pete On Jul 18, 7:01*pm, "Tony" wrote: ok thanks for my last post what if i want to put a date in colum 1 and when its the value in column 2 past ie 36 months past that date i want the date cell to turn red Thanks Tony |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
past cell by date
Tony,
What you are wanting to do is achievable with conditional formatting but I don't understand what you mean. For the 2 cell values (dates) to move apart one must be a function =today() and one a fixed date, which is which and which column do you want highlighted? Mike "Tony" wrote: ok thanks for my last post what if i want to put a date in colum 1 and when its the value in column 2 past ie 36 months past that date i want the date cell to turn red Thanks Tony |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| past date cell colour change | Excel Worksheet Functions | |||
| Cell won't accept date past year 2009 | New Users to Excel | |||
| Can I lock cell contents after current date is past? | Excel Worksheet Functions | |||
| When I open my past invoice it keeps changing date to todays date | Excel Worksheet Functions | |||
| flag date within a cell after 15 days have past? | Excel Worksheet Functions | |||
Linear Mode
