Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default Cell contents changing colors

Just a little correction, it should be:
=DATEDIF(A1,TODAY(),"m")5

otherwise it calculates over 7 month, not 6

"Pieter Kuyck" wrote in message
...
Ken,

With Conditional Formatting
Formula Is
=DATEDIF(A1,TODAY(),"m")6
Select a format.. patterns choose a color

Date in A1 will change of color when the date is more than 6 month ago.

Pieter



"kscroggs" wrote in message

...
| I work with Big Brothers Big Sisters and I am trying to
| schedule our evaluations for 6 months after the original
| match is made. Is there a formula that will make the
| dates change color when they go over the 6 month time
| peroid?
| I hope that this does not have to be a macro!!!!!!
| Thank you,
| Ken Scroggs




Reply
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
Changing cell colors from a function command Joebeone Excel Worksheet Functions 3 February 13th 10 02:11 AM
Changing cell colors Joebeone Excel Discussion (Misc queries) 1 February 11th 10 08:17 PM
changing cell background colors with formulas postal vet Excel Worksheet Functions 5 October 30th 08 08:07 AM
Cell colors or text color changing when date in cell gets closer. Chase Excel Worksheet Functions 5 October 19th 06 08:57 AM
changing cell colors with formula sflcowboy78 Excel Worksheet Functions 2 October 2nd 05 01:19 AM


All times are GMT +1. The time now is 07:20 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"