Code help for dates

**learningexcel123** · 03-23-2012, 11:25 PM

Hello, I am hoping someone can help with a quick code for dates:

What I need IF K(which is a date) is less than or equal to 18months from today's date color code it red

Also, any ideas where I can find things like this for future reference? Like an ebook to read over? Thanks

**learningexcel123** · 03-23-2012, 11:26 PM

Oh, and if possible...what would it be to add IF K is less then 12 months this color with the same code

**Paul** · 03-24-2012, 12:58 AM

Hi Learning, welcome to the forum.

You should use Conditional Formatting for this, not VBA code (macros). See here: http://chandoo.org/wp/2010/01/05/con...rmatting-dates

The helpful bit on that linked page will actually be in the Excel 2003 section, regarding using formulas as the Conditional Formatting test, as there is no built-in "180 days from now" condition.

**learningexcel123** · 03-24-2012, 01:22 AM

Thanks Paul,

This will take some play with what they have but at least it is something. I just have to figure out what to tell the format that I want...tough to explain.