Conditional Formatting Training Expiry Dates

[Graeme Shep]

Hi,

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

Date set at e.g. May-2013.

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

if you can help it would be really appreciated

Regards

Graeme

 

[Pamanabh]

Hi,

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

Date set at e.g. May-2013.

so the formatting would want to make the cell go red when it hit
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

 

[KevUK]

Hi,

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

Date set at e.g. May-2013.

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

if you can help it would be really appreciated

Regards

Graeme.

Hi Graeme

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