Quote:
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.
|
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 .