I must be doing something wrong. It turned the entire column a color.

"BorisS" wrote:

in the conditional formatting, select formula instead of value and use
=mod(Year(today())-Year(b2),5)=0, then set your formatting.

MOD gives you the remainder when one number is divided by another.
--
Boris


"PAR" wrote:

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