Let's say that the expiration date of the contract is in cell B1, and you want all of row 1 to turn
red when you are within 30 days of that date.

Select row 1, the use format / Conditional formatting, select formula is, and use the formula

=($B1-TODAY())<30

Then set the fill to be red, and click OK.

You can copy that formatting down to apply to more rows.

HTH,
Bernie
MS Excel MVP


"Matticace" wrote in message
...
Hello there,
I am trying to create a contract management system and would like to input
all the relevant data into a spreadsheet. A month before a contract runs out
I would like all the data relevant to it to be highlighted or in some way
made obvious that the contract is coming to an end and needs the attention of
the user.
Can anyone help me with this?
Thankyou very much