Conditional format - dates this week & next

Hi

CAn somebody have a look at the attached spreadsheet.

I have a CF in the Tender Return column which changes the cells to red when the tender is due the fllowing week but how can I change this to include also tenders due in the current week?

Also, how do you filter on a color (i.e how to filter on the red bg colour) ?

THIS IS TO WORK IN A 97/2003 WORKBOOK ETC.

Thanks.

Supposing you want the condition to fire between monday of this week and friday of next week, in E2 try

Please Login or Register  to view this content.

as CF formula and extend to other cells