I have realised that you can't add conditional formatting to sheet1 that
references data from from sheet 2, so I am displaying the data from sheet 2
onto sheet 1 which I will hide when completed, I can set conditional
formating using the data but it doesnt seem to work, is it because the
conditional formatting is reading the actual data in the cell (ex in this
case is =Customer_List!C5) instead of whats being displayed (ex 1/5/2007)
which is what I want the formatting to work against?


Is there another way I can do this? I want to ensure that the date field
stays dynamic so as the data gets updated the conditional formatting will do
its trick on the summary page .

Thanks
--
Neall