Conditional Formatting Dates Overlap Excel Formula
This is the same formula used to highlight entire rows in the table using a formula-based conditional formatting rule. The start date must be less than or equal (<=) to at least one other end date and the list. The end date for the project must be greater than or equal to (>=) at least one other start date in the list. If both of these conditions are true, the project dates must overlap another project in that list....