I have 13 worksheets ( sheet 1 being MAIN and remaining sheets 2 - 13 are Months(JAN-DEC) ) . Sheet 1 has (Employee Name , loan , loan date ,loan bal amt , EMI ) . Sheets 2-13 have loan columns in them which when edited are reflected in main sheet and bal loan amt is updated. I want the rows in sheet 2 to sheet 13 to be filled with color and font to be bold and italic IF the sheet name matches the loan month (date) and if any balance is pending . I also want a msg to appear if a cell in loan column is selected.
I dont know how to explain it clearly.
Any other ideas are welcomed . I basically want to data entry guy to know if there is any pending loan for an employee.
For Example
EXAMPLE 1 :- If employee C has taken loan (50000) in jan then highlight the row with his name in sheets 2 to 13 untill loan is cleared . (EMI may vary depending on user entry). If loan is cleared in aug then stop highlight in sheet sept to dec.
EXAMPLE 2 :- If employee F has taken loan (80000) in Apr then highlight the row with his name in sheets 5 to 13 untill loan is cleared . (EMI may vary depending on user entry).
Bookmarks