February 2002 22:28
To: MS-Exchange Admin Issues
Subject: RE: Slightly OT: Conditional Formatting
I created a field called AGE and used the following formula (all one
line):
IIf(DateDiff(d,[Received],Now())=7,DateDiff(w,[Received],Now())
week(s),(IIf(DateDiff(d,[Received],Now())0.99,DateDiff(d
This one's got me stumped - can you guru's help?
One of our desks has a contracted response time of 1 hour for all email.
Management want outlook to display all mails older than one hour in a big
red font. Problem is, conditional formatting in O2K will only allow this for
Today, Last 7 Days etc.
of a message within 0 hours to xx Weeks. Then
maybe you can figure out how to make them red based on that...
-Original Message-
From: Boswell Tim [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 06, 2002 4:30 AM
To: MS-Exchange Admin Issues
Subject: Slightly OT: Conditional Formatting