Conditional formatting with expired dates after current

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

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