Conditional Formatting Training Expiry Dates
 

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.

hi

Select column containing Date set ,
Now go to conditional formatting
Now create new rule

select in rule : Format only cell that contain

choose date occurring form drop down list
now select the option for next month.

and format the font as red .

let me know if it works for you .

Hi Graeme

=IF(A1="","",A1<=TODAY()+30)
The cell reference is presuming that your dates are in column A.