Hi,

i need a little bit help,

i got tracker where i track information and dates when information has been entered,

what i need is Excel to help me:

to flag me 30 days since information been tracked.

for example date: 20/05/2012 goes red after 30 days on 20/05/2012

how can i do that?

i am using Microsoft Excel 2007

Thanks for Your help :)

Your looking for Conditional Formatting.

for example date: 20/05/2012 goes red after 30 days on 20/05/2012But not sure how your data is set up.

What Cells are you using?

How is your data set up?

Are you check two dates against each other,

or are you looking to use today's date?To post a small sample of your work sheet read this:

http://www.computing.net/howtos/sho...MIKE

For example:

A1 todays date ; A2 colum goes red after 30 days from date in colum A1 and stays red until I add comment.

Is it possible?

Thanks D

A2 colum goes red after 30 days from date in colum A1?Not completely sure what you mean by this,

but I'll make a guess that you meancell A2?Unless you really want all of column A to go red.

Try this:

1) Select your cell or Range of Cells, in your case select cell A2

2) On the ribbon click Conditional Formatting

3) Click on New Rules, itâ€™s near the bottom of the dialog box.

4) Click Use Formula to determine which cells to format.5) Enter the formula: =AND(A2="",(A1+30)>=TODAY())

6) Click on the Format button

7) Select the Fill Tab

8) Select a Red color

9) Click OK

10) Click OKMIKE

Ask Your Question

Weekly Poll