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: 4
Default What is formula to have an upcoming date change color?

I have a spreadsheet that shows contract begin and end dates. I would like
the end date to highlight or change colors when it is two months away.
 
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
Change cell color if date exceeds formula Harry K Excel Discussion (Misc queries) 1 March 9th 07 09:51 AM
formula to change color of a cell when date is over a year old? jvmn New Users to Excel 2 June 27th 06 02:30 PM
Upcoming Date alerts Trenton Excel Worksheet Functions 9 May 31st 06 09:50 PM
HOW TO USE A FORMULA TO CHANGE CELL COLOR ACCORDING TO DATE RANGE. terry Excel Worksheet Functions 2 December 27th 04 04:07 AM
compute upcoming Sunday date in a cell CJ Excel Worksheet Functions 2 November 25th 04 03:33 PM


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