Excel 2003 VBA or conditional formatting. Date in one cell needs to format remote cell

Hello everybody,

I have looked hard in the forum for an answer to this, but nothing gets close enough for me to be able to sort the problem on my own. Below is an example of a annual roster on which I'm working. I've only shown a small area, for brevity.

The coloured areas are conditionally formatted. Ivory shows Away, green is for Work, pale blue is a day on which a shift-change may occur, and TD is a Transition Day. The mustard colour is the "base", so I don't need to use up a CF option for those cell-values.

What I'd like to do is collect the date from a cell outside the formatted area, rows 12 and 13 in the extract, and then colour the relevant cell red, as per the example. ie CD has an Expiry date of the 2nd Mar, therefore fill the cell corresponding to the relevant day, F7, in red, I drew a red border round it to show what I mean.

Is it possible to do this with a Conditional Formatting formula, preferable, or is VBA the answer?

Thanks in advance, and any help gratefully accepted