Hi,

In this example the due date goes in column G and row 1 is the top row.
Select the rows to which this applies then

Format|Conditional format - Formula is

enter the formula

=AND($G1<"",$G1<=TODAY())

Pick a colour - OK


chage the column to your column and the 1 to your top row

Mike

"Juliebee" wrote:

I am creating a sheet for tracking outcomes. I want to put the information
into the sheet with a due date for outcomes. e.g data entered [today],
outcome due [7 days later] when the due date arrives I want the row to change
colour, so that anyone reading the sheet is alerted to the overdue outcome
and can deal with it. Any ideas?
--
Kind regards Juliebee