Expiry date in excel

		Microsoft Office Forums > Microsoft Excel > Excel
Expiry date in excel

FAQ

Thread Tools

Display Modes

12-09-2014, 10:16 PM

splinter09 splinter09 is offline

Windows 8

Office 2007

Novice

Join Date: Dec 2014

Posts: 2

Quote:

Originally Posted by Pecoflyer

Hi
you always will have to enter your expiry date somewhere.
Why not enter it in say D1 ( or whatever).
Your expiry date cell ( say A1) - Select it , go to conditional formatting and enter the following formula =A1=$D$1 and format as required.

please explain to me in steps....thank you

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel pivot table with a DATE value field for some reason stops at a certain date	angie450	Excel Programming	2	08-19-2014 08:50 AM
Letter date changes when merging with Excel - not the format, the actual date!	Smallweed	Mail Merge	1	02-07-2014 06:00 PM
Date format in excel vba	LaercioNB	Excel	3	08-09-2013 06:33 AM
Date problem in excel 2007	msheyworth	Excel	2	06-12-2012 05:10 AM
Excel Date Alert?	Kelleigh	Excel	1	12-05-2008 09:35 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:18 AM.