View Single Post
  #12  
Old 11-15-2006, 10:24 AM
oldchippy's Avatar
oldchippy oldchippy is online now
"Eagle Eyed" Forum Moderator
 
Join Date: 14 Feb 2005
Location: Worcester, UK
MS Office Version:Excel 2003 (Work) and 2007 (Home)
Posts: 6,096
oldchippy is a jewel in the rough
We all started where you are, so let me explain. Ignore my column of date I only did that to show you the formatting that can be applied to cells that dates are within 14 days of TODAY().

What you need to do is apply this formatting to you date cells in your spreadsheet. Once you have done one, you can double-click on the Paintbrush icon and click on all your date cells to apply the same formatting.

Try it on a test spreadsheet, so you understand what's going on.

OK?
__________________
oldchippy
-------------


Click here >>> Top Excel links for beginners to Experts

Forum Rules >>>Please don't forget to read these
Reply With Quote