Highlight intersecting date ranges in row

[neobux]

Hey guys,

I have a UDF which checks whether any of the 5 date ranges in a row are intersecting or not and returns TRUE or FALSE. That works.
But I want it to go a step further, as in to HIGHLIGHT (color the cells) the date ranges which are overlapping.

Here's the UDF:

Please Login or Register  to view this content.

I've also attached the excel file:

intersect date ranges.xls.

Any ideas would be appreciated. Thanks!

[Kenneth Hobson]

Use Data Validation.