Posted to microsoft.public.excel.worksheet.functions

Teethless mama Teethless mama is offline

external usenet poster

Posts: 3,718

conditional formatting or formulae to show elapsed dates

=IF(TODAY()B2,"Expired","OK")

"Jo" wrote:

I have a large sheet showing dates of expiry. I want to see at a glance
which have elapsed.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
Combine Conditional Formatting Rules formulae	Fred	Excel Discussion (Misc queries)	3	March 16th 07 02:27 AM
Conditional formate:show by color when expiration dates are overdu	dan	Excel Discussion (Misc queries)	0	August 24th 06 10:27 PM
Nested functions in conditional formatting formulae	Joseph	Excel Discussion (Misc queries)	3	October 20th 05 11:52 PM
show elapsed time ?	heathcliff	Excel Discussion (Misc queries)	3	June 14th 05 09:52 PM
Formulae, conditional formatting & macro security	Kevin Lucas	Excel Discussion (Misc queries)	7	March 15th 05 01:10 PM

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

About Us

"It's about Microsoft Excel"