LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 128
Default change color after 60 days

I have seen other posts for this but for some reason the suggestions did not
work for me. I created a sheet and my E column is "Check Date" ... I would
like to set it so the date will change to red 60 days after that date. ie,
check dated 01/04/08, will turn red on/after 03/05/08.
(excel 2003)
Thank you!!
 
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 to change the default of 30 days change history Andy Smith[_2_] Excel Discussion (Misc queries) 6 October 23rd 07 11:57 PM
Re Change 5 week days to 7 days in this formula pano Excel Worksheet Functions 7 February 1st 07 04:20 PM
How change days of change history tracking? DonSpmp Excel Worksheet Functions 3 August 25th 06 01:13 AM
I want any date 90 days or older from current date change color Big Abalone Excel Worksheet Functions 5 April 23rd 06 05:01 AM
How to change the default Border, Font Color, and Cell Color Elijah Excel Discussion (Misc queries) 3 November 2nd 05 11:52 PM


All times are GMT +1. The time now is 02:35 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"