display cell content based on date criteria

  • Thread starter Thread starter hsg
  • Start date Start date
H

hsg

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 ?
 
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,""),"")
 
Format/ Conditional Formatting/ Cell value is/ greater than: =TODAY()
Select a white font (or colour equal to you background colour).
 
Back
Top