Hello again. Looking for help again.
Here is the table where
D is Date money taken by client
AW-BH are the months of the year each cell contains the % paid by client. Normally when the client is paying before or at the end of his month he pays whatever shows H column.
As example deadline for % payment of money taken on 05.01.14 is 05.02.14 If client did not paid by his deadline there is an extra payment as addition to his % which is calculated by formula
(%/30) * X = Extra payment
Where X is days the payment delayed. 30 the number of days in month
And finally the question: Is there any way to display actual calculated missing payment in cells with different font color or highlighted in different color ? It seems for me something unreal, but one more picture to help you understand my poor English
Here is client who payed on 14.06 and did not turned up for payment on 14.07
22 days left from that date. So if he turns out today highlighted in blue is what he have to pay according to formula I did manually. Is there any way to make this to be done by macro ?
fuf. finally i wrote this
Hope someone will understand what I want
Here is the table where
D is Date money taken by client
AW-BH are the months of the year each cell contains the % paid by client. Normally when the client is paying before or at the end of his month he pays whatever shows H column.
As example deadline for % payment of money taken on 05.01.14 is 05.02.14 If client did not paid by his deadline there is an extra payment as addition to his % which is calculated by formula
(%/30) * X = Extra payment
Where X is days the payment delayed. 30 the number of days in month
And finally the question: Is there any way to display actual calculated missing payment in cells with different font color or highlighted in different color ? It seems for me something unreal, but one more picture to help you understand my poor English
Here is client who payed on 14.06 and did not turned up for payment on 14.07
22 days left from that date. So if he turns out today highlighted in blue is what he have to pay according to formula I did manually. Is there any way to make this to be done by macro ?
fuf. finally i wrote this
Hope someone will understand what I want
