jd_abramson
New Member
- Joined
- Oct 7, 2010
- Messages
- 6
I have posted the spreadsheet below. (no macros)
http://dl.dropbox.com/u/3345769/invoice.xlsx
I have a spread sheet that is used for billing out time. The times cannot overlap. So I have created conditional formatting to indicate that the times are overlapping. There is a bug somewhere that creates false positives shown in the picture.
=SUMPRODUCT(($B136<$C136:$C140)*($C136>$B136:$B140))>1
True= Red fill
Thank you for your help......
http://dl.dropbox.com/u/3345769/invoice.xlsx
I have a spread sheet that is used for billing out time. The times cannot overlap. So I have created conditional formatting to indicate that the times are overlapping. There is a bug somewhere that creates false positives shown in the picture.
![88ewow8p66z9zkmrill_none.jpg](/board/proxy.php?image=http%3A%2F%2Fwww.imageurlhost.com%2Fimages%2F88ewow8p66z9zkmrill_none.jpg&hash=d410dd733e63521c3905bcb82827513c)
=SUMPRODUCT(($B136<$C136:$C140)*($C136>$B136:$B140))>1
True= Red fill
Thank you for your help......