Comparing dates

JimH · May 21st, 2002, 02:12 AM

In conditional formatting I use the formula =(A1-TODAY())<6 to alert me when a delivery date is approaching. I have it fill the cell red with a yellow font.

Currently the cell stays red even after the due date is past. I'd like the cell to return to a regular non-formatted cell once the due date is past.

How should I modify my formula to accomplish this?

Ian Mac · May 21st, 2002, 02:30 AM

Try using:

=AND((A1-TODAY())>0,(A1-TODAY())<6)

Hope this helps

JimH · May 21st, 2002, 11:49 PM

Ian,

That solved the problem. Thanks for your help.

May 21st, 2002, 02:30 AM	#2
Ian Mac MrExcel MVP Join Date: Feb 2002 Location: Newcastle, UK Posts: 1,174	Try using: =AND((A1-TODAY())>0,(A1-TODAY())<6) Hope this helps __________________ "Have a good time......all the time" Ian Mac

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 21st, 2002, 02:12 AM	#1
JimH Board Regular Join Date: Apr 2002 Posts: 64	In conditional formatting I use the formula =(A1-TODAY())<6 to alert me when a delivery date is approaching. I have it fill the cell red with a yellow font. Currently the cell stays red even after the due date is past. I'd like the cell to return to a regular non-formatted cell once the due date is past. How should I modify my formula to accomplish this?

May 21st, 2002, 11:49 PM	#3
JimH Board Regular Join Date: Apr 2002 Posts: 64	Ian, That solved the problem. Thanks for your help.