Yes, I have the correct cell selected and a format.

Whether I use the absolute reference or not all the cells are formated with
the conditional format, not just the 5 year incremental dates.


"Chip Pearson" wrote:

It works for me. Are you sure you have the proper cell selected
when you apply conditional formatting, and are you sure you
actually specified a format?


"PAR" wrote in message
...
does not make any difference if absolute reference is used,
cell does not
change color

"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