I added the missing columns/data and everything is there now...and I also added a new TAB for color code for each membership types and color coded each membership in column D....but left the main TAB uncolored...as I just want Allowance column N in main TAB to show the color with the logic formula...like the 2013 worksheet.
Hope this helps and also I didn't do the calculation at bottom...
Many thanks in advance.
Bookmarks