PC Review


Reply
Thread Tools Rate Thread

Conditional formatting with expired dates after current

 
 
Josh
Guest
Posts: n/a
 
      13th Apr 2010
I am trying to get a cell to turn Red if the date that is in the cell is less
than or equal to the current date. The formula I have in it already is:
=EDATE(D2, 12)
This takes the date that I plug into the column before it and just adds 12
months to it. Thanks for any help you can offer.

V/R
 
Reply With Quote
 
 
 
 
Max
Guest
Posts: n/a
 
      13th Apr 2010
TODAY() is what you need to compare with,
viz. use as the CF formula for that cell: =EDATE(D2, 12)<=TODAY()
Format to taste, ok out. Success? hit YES below
--
Max
Singapore
---
"Josh" wrote:
> I am trying to get a cell to turn Red if the date that is in the cell is less
> than or equal to the current date. The formula I have in it already is:
> =EDATE(D2, 12)
> This takes the date that I plug into the column before it and just adds 12
> months to it. Thanks for any help you can offer

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formating For Expired Dates =?Utf-8?B?UHJvaG9jaw==?= Microsoft Excel Programming 1 8th Nov 2006 05:04 PM
Conditional Formatting on Current =?Utf-8?B?U3RldmVu?= Microsoft Access Form Coding 1 12th Sep 2006 10:26 PM
Conditional Format: Expired dates wanting cell to change color =?Utf-8?B?RGFu?= Microsoft Excel Misc 1 24th Aug 2006 10:27 PM
Re: conditional formatting with dates Bob Phillips Microsoft Excel Misc 1 26th Aug 2004 08:57 PM
Formatting Problem-Highlighting a cell when date has expired past current date alancyoung Microsoft Excel Misc 1 19th Feb 2004 05:14 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:37 AM.