Date sensitive cells

M

Matticace

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
 
B

Bernie Deitrick

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
 
G

greg7468

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 colou
to suit, click OK.

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

HTH
 
Top