Hi there,

Is it possible to use a form of conditional formatting so that dates will highlight in red 1 week before their occurence e.g. if a cell contains the date 07/02/2005, to condition the cell to highlight in red on 01/07/2005.

Many thanks

Andy