Date sensitive cells
 

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

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

Hi,
highlight the cells you want to "make obvious"

go to Format Cells Conditional Formatting

change cell value is to Formula is and put
=A1(cell with contract end date)<TODAY()+30

Click on Format and either change the font colour or cell fill colour
to suit, click OK.

This will change the cells when the contract end date comes within 30
days of the current date, you can change this to suit.

HTH.


--
greg7468


------------------------------------------------------------------------
greg7468's Profile: http://www.excelforum.com/member.php...fo&userid=9031
View this thread: http://www.excelforum.com/showthread...hreadid=382779