LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 1
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I set expiry document dates on Excel 2003? GG Excel Discussion (Misc queries) 2 April 29th 10 01:05 PM
Re training expiry date formula required Manxy Excel Programming 3 July 22nd 09 07:05 PM
conditional formatting expiry dates mooty Excel Worksheet Functions 1 April 14th 09 04:24 AM
Can I set up a sheet for reagents that will flag expiry dates? haem Excel Discussion (Misc queries) 1 March 6th 09 02:27 PM
I want format cells to have expiry dates & highlight Aims Excel Worksheet Functions 1 January 21st 09 06:45 AM


All times are GMT +1. The time now is 11:18 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"