G
Guest
Hi all, sorry about the subject line but I don't know how to define the
problem in a short way.
Basically, a work buddy has a spreadsheet with the following criteria
Column C contains a manually input date which displays a maturity date of a
service in the following format dd/mm/yyyy
Column D COntains a value for the service in a two decimal currency
Assume there are 10 rows of each
When I run the macro, I would like to have a cell display the sum of the
total values.
Now the interesting bit. If I run the macro and the date value of colum C
is less than TODAY's date, I would like to miss leave out the value field for
that particular row. Ideally, turning that row RED also would be fantastic
as it would immediately show matured services without having to look to
closely.
Thanks in advance
Mal
problem in a short way.
Basically, a work buddy has a spreadsheet with the following criteria
Column C contains a manually input date which displays a maturity date of a
service in the following format dd/mm/yyyy
Column D COntains a value for the service in a two decimal currency
Assume there are 10 rows of each
When I run the macro, I would like to have a cell display the sum of the
total values.
Now the interesting bit. If I run the macro and the date value of colum C
is less than TODAY's date, I would like to miss leave out the value field for
that particular row. Ideally, turning that row RED also would be fantastic
as it would immediately show matured services without having to look to
closely.
Thanks in advance
Mal