View Single Post
  #1   Report Post  
PAR
 
Posts: n/a
Default Conditional Format Formula Needed

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