Hi,
I am looking for a way to conditional format a table in which Staff has exceeded his leave entitlement.
I have attached an example.
Leave accrued each month on pro rated basis is mentioned in Grey color from C3 to L3
A staff can take max leave depending on what he she has accrued each month (2.5 each month)
eg: STAFF 1
Leave already taken = 12
Can take max 24.5 days leave until Nov 2020
However 12 + 5 + 4 + 8 is 28 (which is exceeding the entitlement until that month)
Any cell above entitlement should be highlighted with Red.
Thank you
Bookmarks