Conditional formatting

pk8080 - Jan 20, 2010 at 07:56 AM
 Trowa - Jan 22, 2010 at 09:23 AM

I am trying to format a cell in B1 to show the date 18 months from the date in A1 and turn red if it goes over the 18 months.

Can anyone help?

3 responses

If B1 is 18 months later then A1, how can the difference be bigger then 18 months???

Can you explain.

Hi, basically A1 has a date for example 01/01/08, I want cell B1 to go red 18 months after the date of A1.

Does that make sense?
Yes it does.

First we have to determine 18 month after the date in A1, so format cell C1 into date and put the following formula in it: =EOMONTH(A1,18).
Now select B1 and goto conditional formatting, select formula is and input: =B1>C1, select the color red and confirm by hitting OK.

Does this suit your needs?
If not the answer will have to wait till next week, since my weekend starts now.

Best regards