LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Flagging dates with conditional formatting

I am trying to set up conditional formatting so that it flags me when it is
within 3 months & 1 month of a date. For example, I have a list of the dates
each of my staffs' CPR certifications are to expire. If it expires on
10/1/09, I would like the cell to turn yellow on 7/1/09, and red on 9/1/09.
The expiration date will be different for each staff member in each row.

Thanks
 
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
Conditional Formatting with Dates JoAnn New Users to Excel 2 February 25th 08 03:12 PM
Conditional Formatting - Dates Ali Cat Excel Discussion (Misc queries) 2 December 6th 07 09:15 AM
Conditional Formatting-dates Eva Excel Worksheet Functions 6 December 12th 06 10:20 AM
conditional formatting with dates Vabu3184 Excel Worksheet Functions 2 March 27th 06 02:11 AM
Conditional Formatting for dates spacerocket Excel Worksheet Functions 2 November 4th 04 10:13 AM


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

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

About Us

"It's about Microsoft Excel"