Excel Dumbo Excel Dumbo is offline

Senior Member

Posts: 105

Thanks Claus for your valuable time. The formula worked for the first two dates.

There is no "Expired" coming up for 30/09/2013 and it is turning red when it should not. Please refer attached

Attached Files

Conditional FOrmatting for Dates.zip (3.4 KB, 31 views)

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 Formatting - Dates	RWilson	Excel Worksheet Functions	0	October 8th 12 10:21 AM
Using Dates in Conditional Formatting	Marie FP[_2_]	Excel Worksheet Functions	9	August 19th 09 12:18 AM
Conditional Formatting - Dates	Ali Cat	Excel Discussion (Misc queries)	2	December 6th 07 09:15 AM
Conditional formatting - Dates	Duncan	Excel Discussion (Misc queries)	2	July 23rd 07 10:50 PM
Conditional Formatting - dates	Kat	Excel Discussion (Misc queries)	9	December 14th 06 06:36 AM

All times are GMT +1. The time now is 09:42 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us