I just started using some conditional formatting, basic stuff.

Basically, if this cell's value reads 'complete', color it blue, if it is marked 'on hold' color it pale green, 'in progress' red, etc. Handy visual stuff.

NOW, I'm hoping one of you gurus out here can tell me whether I can set up a rule across two cells and format based upon the difference between the two?
Say, I've got two columns of dates, and, in order to audit the data, I need to know if those dates are anything other than a year apart.

01/01/2014 - 01/01/2015
wouldn't change formatting because it's a year
but

08/01/2014 - 01/01/2015
would change color because it's not a year difference between the two values.

Make sense? Is this possible?