RE: Slightly OT: Conditional Formatting

2002-02-07 Thread Boswell Tim
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

Slightly OT: Conditional Formatting

2002-02-06 Thread Boswell Tim
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.

RE: Slightly OT: Conditional Formatting

2002-02-06 Thread Nikki Peterson - ITCX
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