Question

		Microsoft Office Forums > Microsoft Excel > Excel
Question

FAQ

Thread Tools

Display Modes

12-02-2011, 09:26 AM

Pecoflyer

Windows XP Question

Office 2003

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

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

« 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 04:02 AM.