Originally Posted by Graeme Shep

Hi,

I have a training matrix set up for the company i work for, i need to set a conditional format to highlight 1 month before the training expires for each individual.

Date set at e.g. May-2013.

so the formatting would want to make the cell go red when it hits Apr-2013.

if you can help it would be really appreciated

Regards

Graeme.