L
LiveUser
I receive reports weekly and I am creating a receipt log. When I receive the
report I enter the date I received it.
My date has to be setup as d-mmm-yyyy.
I create the year 2008 daily on another worksheet and name it Year2008.
In each cell, C2:BB19, I have a list with every day of the year of 2008,
"Year2008".
I also have conditional formatting referring to cells C1:BB1, Weekly dates.
If the dates from C2:BB19 don't match, then, if early the cell turns yellow,
and if late the cell turns orange.
In the event that within a report, not the day I received the report, but
what is actually in the report gives me a late information, I want to select
a special date, for instance, *d-mmm-yyyy, rather than d-mmm-yyyy. Therefore
I can create another condition where if there is a "*" before the date then
the cell will turn red.
I want to add another 2008 year to my already 2008 year except with someway
of refering to something late in the report i received, like the *.
My problem is, as far as I know, I can't create a date that is recognized as
*d-mmm-yyyy.
This may be as easy as creating another d-mmm-yyyy for 2008 and then
inserting the *. But, I don't know how.
Help?
Thank you.
report I enter the date I received it.
My date has to be setup as d-mmm-yyyy.
I create the year 2008 daily on another worksheet and name it Year2008.
In each cell, C2:BB19, I have a list with every day of the year of 2008,
"Year2008".
I also have conditional formatting referring to cells C1:BB1, Weekly dates.
If the dates from C2:BB19 don't match, then, if early the cell turns yellow,
and if late the cell turns orange.
In the event that within a report, not the day I received the report, but
what is actually in the report gives me a late information, I want to select
a special date, for instance, *d-mmm-yyyy, rather than d-mmm-yyyy. Therefore
I can create another condition where if there is a "*" before the date then
the cell will turn red.
I want to add another 2008 year to my already 2008 year except with someway
of refering to something late in the report i received, like the *.
My problem is, as far as I know, I can't create a date that is recognized as
*d-mmm-yyyy.
This may be as easy as creating another d-mmm-yyyy for 2008 and then
inserting the *. But, I don't know how.
Help?
Thank you.