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 past cell by date

ok thanks for my last post
what if i want to put a date in colum 1 and when its the value in column 2
past ie 36 months past that date i want the date cell to turn red
Thanks Tony


 
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
past date cell colour change flasherr Excel Worksheet Functions 2 July 17th 08 06:17 PM
Cell won't accept date past year 2009 lbrown New Users to Excel 2 February 15th 06 01:51 PM
Can I lock cell contents after current date is past? Excel User Greg Excel Worksheet Functions 0 January 16th 06 06:47 PM
When I open my past invoice it keeps changing date to todays date Stop date changing to todays in Excel Excel Worksheet Functions 2 October 7th 05 04:54 PM
flag date within a cell after 15 days have past? SAUDIA Excel Worksheet Functions 2 August 19th 05 04:33 PM


All times are GMT +1. The time now is 09:27 AM.

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"