Conditional Formatting

Hi,

I am in the same position as Maureen. I am trying to have conditional format for a training matrix, where I have a column headed by the renewal frequency (say 2 year or 3 years, as the case might be). Beneath that are various dates that personnel performed the training. The goal is to have the color change to Yellow (if the expiry date is within 90 days from today), and Red (if the expiry date is passed). I tried a basic formula referring to the frequency multiply by 365 but nothing happens.