On 22/04/2016 01:05 PM, Claus Busch wrote:
Hi Ahmed,

Am Fri, 22 Apr 2016 06:16:24 +0530 schrieb ahmed:

Monthly fees are entered in column E. While most of the students pay in
full, some make part payment or for the following month also in advance.
In those cases when monthly payment is not equal to 3000, I want this
formula result to appear in a different color.

look he
https://onedrive.live.com/redir?resi...=folder%2cxlsm
for "Student_Fees".
You also have to change the formula for the month because it doesn't
work correct when year changes.


Regards
Claus B.


Thank you, Claus.

I appreciate your effort to answer my question in details. I also got an
added bonus of finding out the balance outstanding. Your worksheet is
very neat and descriptive.

Let me try to understand the formulas in columns C & D. If I have any
difficulties, I will come back to you.

Thank you for your time again.

Kind regards,
Ahmed.

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus