Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What formula would transpose stale dated cells?
I am trying to have stale dated cells copied into blank cells but cannot seem
to find a formula that might do that. Any character in the new cell would be fine as long as it highlights the old dates. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
What formula would transpose stale dated cells?
Just venturing some thoughts for you (you've had no responses so far)
Assuming the dates are listed in A2 down you could apply conditional formatting by selecting col A, then place this in the "Formula Is" box: =AND(ISNUMBER(A1),A1<TODAY()) Then just format the fill color, etc to taste This will highlight all cells in col A with dates earlier than today You could also place the same formula in an adjacent col, say in E2: =AND(ISNUMBER(A1),A1<TODAY()) then copy E2 down as far as required Then apply autofilter on col E, choose: TRUE to filter out all lines with dates earlier than today -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Debbie" wrote: I am trying to have stale dated cells copied into blank cells but cannot seem to find a formula that might do that. Any character in the new cell would be fine as long as it highlights the old dates. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charting Dated Data | Charts and Charting in Excel | |||
blank vs. 0 when plotting a dated timescale graph | Excel Worksheet Functions | |||
In Excel can you have a cell generate the last dated modified?? | Excel Discussion (Misc queries) | |||
print spreadsheet with each coming day dated on it for 2006. | Excel Discussion (Misc queries) | |||
Alternatives for Excel for charting dated time-series? | Charts and Charting in Excel |