| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
display cell content based on date criteria
My worksheet contains several columns of data, first column being DATE.
each day new information is filled in column B to K, but in Column A, all the dates are already filled up, say 1 Jan 2009 to 31 Dec 2009. I want that a date should not be visible before that date actually arrives, i.e. on 5th jan, I should see on first 5 rows (jan 1 to jan5) On 30th Dec, I should see all rows from Jan 1 to Dec 30, but not Dec 31. Is is possible ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display cell content based on date criteria
In cell A2 enter the first date...Enter the below formula in A3 and copy down
as required.. =IF(A2<"",IF(A2+1<=TODAY(),A2+1,""),"") -- Jacob "hsg" wrote: My worksheet contains several columns of data, first column being DATE. each day new information is filled in column B to K, but in Column A, all the dates are already filled up, say 1 Jan 2009 to 31 Dec 2009. I want that a date should not be visible before that date actually arrives, i.e. on 5th jan, I should see on first 5 rows (jan 1 to jan5) On 30th Dec, I should see all rows from Jan 1 to Dec 30, but not Dec 31. Is is possible ? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
display cell content based on date criteria
Format/ Conditional Formatting/ Cell value is/ greater than: =TODAY()
Select a white font (or colour equal to you background colour). -- David Biddulph "hsg" wrote in message ... My worksheet contains several columns of data, first column being DATE. each day new information is filled in column B to K, but in Column A, all the dates are already filled up, say 1 Jan 2009 to 31 Dec 2009. I want that a date should not be visible before that date actually arrives, i.e. on 5th jan, I should see on first 5 rows (jan 1 to jan5) On 30th Dec, I should see all rows from Jan 1 to Dec 30, but not Dec 31. Is is possible ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filling in a cell based on another cells date criteria | Excel Worksheet Functions | |||
| Why does my cell content display as '############'? | Excel Discussion (Misc queries) | |||
| Display contents of cell based on criteria | Excel Worksheet Functions | |||
| display a drop-down list based on the content of another cell | Excel Discussion (Misc queries) | |||
| How do I change content of a cell based on date | Excel Worksheet Functions | |||
Hybrid Mode
