Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Quote:
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 . |
#3
|
|||
|
|||
Quote:
=IF(A1="","",A1<=TODAY()+30) The cell reference is presuming that your dates are in column A. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set expiry document dates on Excel 2003? | Excel Discussion (Misc queries) | |||
Re training expiry date formula required | Excel Programming | |||
conditional formatting expiry dates | Excel Worksheet Functions | |||
Can I set up a sheet for reagents that will flag expiry dates? | Excel Discussion (Misc queries) | |||
I want format cells to have expiry dates & highlight | Excel Worksheet Functions |