Hello,
I'm using Excel online, so unfortunately no macros...
I am building an absence/leave sheet. It is quite a simple sheet.
Columns are Name(A), Date from (B), Date To (C), Half day(D) Days leave (E) (formula - =IF(ISBLANK(C3),"",NETWORKDAYS(B3,C3))), Name (G), Leave entitlement (H), Remaining days(I) (Formula - =H3-SUMIF(A:A,G3,E:E))
This all works OK.
I am trying to extend it now so if one person requests to take leave which crosses over dates that already exist in my list of date ranges, I am alerted - highlight the row red/put up an alert/basically anything. I've tried using conditional formatting, but haven't been successful.
Anyone able to suggest what I could try next?
Many thanks for reading.
I'm using Excel online, so unfortunately no macros...
I am building an absence/leave sheet. It is quite a simple sheet.
Columns are Name(A), Date from (B), Date To (C), Half day(D) Days leave (E) (formula - =IF(ISBLANK(C3),"",NETWORKDAYS(B3,C3))), Name (G), Leave entitlement (H), Remaining days(I) (Formula - =H3-SUMIF(A:A,G3,E:E))
This all works OK.
I am trying to extend it now so if one person requests to take leave which crosses over dates that already exist in my list of date ranges, I am alerted - highlight the row red/put up an alert/basically anything. I've tried using conditional formatting, but haven't been successful.
Anyone able to suggest what I could try next?
Many thanks for reading.