Library Records - Conditional Formatting Applied
Student Name
Student 1
Student 2
Student 3
Student 4
Student 5
Student 6
Student 7
Student 8
Student 9
Student 10
Student 11
Student 12
Student 13
Student 14
Student 15
Student 16
Student 17
Student 18
Student 19
Student 20
Total Fines Collected
Book Title
Mathematics Grade 10
Chemistry Basics
English Literature
Physics for Beginners
Biology Textbook
History of Kenya
Mathematics Grade 10
Geography Atlas
Chemistry Basics
Computer Science 101
English Literature
Physics for Beginners
Biology Textbook
History of Kenya
Mathematics Grade 10
Geography Atlas
Computer Science 101
Chemistry Basics
English Literature
Physics for Beginners
Borrow Date
01/05/2025
01/08/2025
01/10/2025
01/12/2025
15/01/2025
18/01/2025
20/01/2025
22/01/2025
25/01/2025
28/01/2025
30/01/2025
02/02/2025
02/05/2025
02/07/2025
02/10/2025
02/12/2025
15/02/2025
18/02/2025
20/02/2025
22/02/2025
Return Date
01/12/2025
15/01/2025
20/01/2025
19/01/2025
22/01/2025
25/01/2025
27/01/2025
02/05/2025
02/01/2025
02/04/2025
02/10/2025
02/09/2025
02/12/2025
14/02/2025
17/02/2025
19/02/2025
22/02/2025
25/02/2025
27/02/2025
03/01/2025
Status
Returned
Returned
Overdue
Returned
Returned
Overdue
Returned
Borrowed
Returned
Returned
Overdue
Returned
Borrowed
Borrowed
Borrowed
Borrowed
Borrowed
Borrowed
Borrowed
Borrowed
Fine Amount
Ksh 0.00
Ksh 0.00
Ksh 50.00
Ksh 0.00
Ksh 0.00
Ksh 100.00
Ksh 0.00
Ksh 0.00
Ksh 0.00
Ksh 0.00
Ksh 150.00
Ksh 0.00
Ksh 0.00
Ksh 0.00
Ksh 0.00
Ksh 0.00
Ksh 0.00
Ksh 0.00
Ksh 0.00
Ksh 0.00
Ksh 300.00