Question

		Microsoft Office Forums > Microsoft Excel > Excel
Question

FAQ

Thread Tools

Display Modes

12-12-2011, 04:10 PM

jmsa7

Windows XP Question

Office 2007

Novice

Join Date: Dec 2011

Posts: 2

Quote:

Originally Posted by Pecoflyer

Hi and welcome to the board

Supposing your date is in A1 enter the following conditions for

RED : =A1<DATE(YEAR(TODAY())-4,MONTH(TODAY()),DAY(TODAY()))
GREEN =A1<>""

Cell will stay default color if empty

Sorry but could you tell me exactly where do I put that conditions?

Thx

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
ppt question	fat	PowerPoint	0	10-06-2011 01:33 PM
Hypertext Question	Juc1	Word	6	05-05-2011 06:09 AM
One to many and many to one question	Girlie4	Excel	3	08-09-2009 08:02 PM
Need help with this question...	lllDNYlll	Outlook	0	05-04-2006 07:17 AM
Categories question & replying with attachment question	glitzymama	Outlook	0	03-15-2006 09:32 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:47 PM.