User Profile
AaronL89
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
Conditional Formatting if notblank & blank same formula
Good morning, Trying to create a conditional formatting rule, that if: Cell B6 is NOTBLANK but Cell L6:N6 is BLANK if should highlight the cells. I've tried different forumlas, but unable to use & as its a conditional formula rule. Any idea's, or something I'm missing? Thanks.Solved867Views0likes1CommentChecking if a time range falls between another time range
Good morning, I'm looking for a formula to help me check if a time range falls between another time range, please see example table below: A B C D E F G Date Time From Time To Employee Time From Time To Present? 9/09/2021 19:00 01:15 John 8:00 9:00 9/09/2021 19:00 01:15 Mary 13:50 15:30 10/09/2021 20:00 00:30 David 10:20 11:00 In this example, I'd like G to return True/False based on if E and F falls between B and CSolved7.5KViews0likes10Comments
Groups
Recent Blog Articles
No content to show