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: 5
Default Conditional Formating for dates beyond 30, 60, 90 to be high light

My spread sheet has sales prospects names, numbers, titles, etc. I also have
a column titled "last date of contact" with dates in the cells. I want the
dates in these cells to change color or the cell to be high lighted when that
date goes beyond 30, 60 or 90 days.
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 formating on dates Margotbf Excel Discussion (Misc queries) 6 May 28th 08 02:46 PM
Excel should high-light Rows & Columns when cell selected. RS Setting up and Configuration of Excel 1 June 28th 06 11:26 AM
Install dates formating using conditional formating? Jerry Eggleston Excel Discussion (Misc queries) 2 November 9th 05 05:49 PM
CONDITIONAL FORMATING DATES tomklem Excel Discussion (Misc queries) 3 October 7th 05 04:24 PM
high light row your working in kcholly Excel Discussion (Misc queries) 3 March 29th 05 08:35 AM


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