AND function
Excel » Functions » Logical » AND function »
The image above demonstrates the AND function with two logical expressions. If the value in column B is equal to […]
IF function with AND function – multiple conditions
The AND function allows you to have multiple conditions in an IF function, you can have up to 254 arguments. […]
Highlight lookups in relational tables
This article demonstrates a worksheet that highlights lookups across relational tables. I am using Excel defined Tables, if you add […]
Find numbers in close proximity to a given number
This article demonstrates how to apply Conditional Formatting formula to a cell range, it finds cells that are in close […]
Count entries based on date and time
Question: My issue is that I get the date in this format: 7/23/2011 7:00:00 AM I am trying to count […]
The picture above shows you conditional formatting formula that highlights matching records based on criteria in row 3 and 4. […]
Setting up your work hours in a weekly schedule
The image above demonstrates conditional formatting highlighting hours outside work hours, those cells are filled with grey except weekends. Conditional formatting […]
Question: I have a list that I keep adding rows to. How do i create a border that expands as […]