I have a list of transaction rows on a spreadsheet. The column to the far left contains dates for each transaction.

On another spreadsheet I have a matrix of date intervalls like (one cell for each date):
2010-04-02 2010-06-03
2010-03-02 2010-06-02

Is it possible to create a conditional formatting that evaluates on the matrix of date intervalls? I.e. if a date in my list of transactions is found in the date ranges specified, then change its formatting?

Thanks!
Erik