Date expiry conditional formatting in Excel 2007 (I think it is the 2007 version anyway)

Hey all,

I am struggeling with getting my certificats expiry dates light up 2 years, 1 year; 6 months, ... before expiry and on expiry.
With this in the boxes. "- 2 years" in a green box. "-1 year" in a light green box. "- 6 months" in a yellow box, ...

See attached for my file. I tried with, the less then 2 years valid, but struggle with this pretty some. Tried so many codes so far in conditional formatting but not working all as should/hoped.

Hope anyone can help me out with this?

Thanks so much for the help in advance,

Nico

Hi,

Could you post another version of this with an example of what you'd like it to look like when things are expired or due to expire?

Attached now how I would like it to look when curtain times are elepsed on from the Expiry dates entered.

Also how to make it look white when no date is entered yet if possible.

Thanks very much,

Nico

Like this?

Duplicate thread: http://www.excelforum.com/excel-2007...on-anyway.html

Wholy F***,

That is fast and fully filled in. :-)

Perfect work Spencer101.

Love ya mate,

Nico

Not a problem mate.

I prefer this version... It will only flag up the relevant expiry range...

So if it expires within a year it wont highlight the "within 2 year" one too.

S.

Awsome man,

Even better this way yes. :-)

Didn't know this was also possible.

Will mark this thread for sure as solved now.

Thanks again super much.

Nico

Don't forget to hit the little star to the bottom left of a post to give me some credit

Just did. :-)

Well, thank you very much for wasting my time.

I just spent quite some time working on this, before I saw Cutter's notice in your other thread that this was a duplicate question that had already been solved.

I could have spent my time on other things.

This is very inconsiderate and shows that you have not understood the forum rules. Please read them again and then stop wasting people's time with duplicate posts.

regards,