Excel flags cells
 

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

Excel flags cells
 

Format/ Conditional Formatting
--
David Biddulph

"Chadersmith" wrote in message
...
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