absolute reference does not make any difference - does not apply format as
needed

"Chip Pearson" wrote:

You should use absolute referencing.
=MOD(YEAR(TODAY())-YEAR(B2),5)=0
should be
=MOD(YEAR(TODAY())-YEAR($B$2),5)=0


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Chip Pearson" wrote in message
...
Try the following formula:

=MOD(YEAR(TODAY())-YEAR(B2),5)=0


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"PAR" wrote in message
...
I would like to have a cell turn a color when the value of the
following
formula is a multiple of 5.

Year(today())-Year(b2)

b2 = date of hire

Thank you