Excel flags cells

[Chadersmith]

Hi,

I have a spreadsheet that was created by another individual where we have
two columns of dates. The purpose of the dates is to make sure one year does
not elapse between a task which is performed. Currently the cells will turn
red if a year has elapsed between the two dates - there is no macro currently
written for this. I have not been able to figure out how this was done. I am
able to duplicate the information by copying and pasting but do not know how
it is done fundamentally. Any thoughts are appreciated.

Thanks,
Chad

 

[David Biddulph]

Format/ Conditional Formatting