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.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional