Nice bit of coding!! I tweaked it a bit to add minutes and write !!OVERDUE!! instead of hours, and that's close enough! Can't get it to conditionally format, but at least it gives them at-a-glance view of what's outside it's agreed time. They'd shrunk the 'received' field so they couldn't see the time - you should've seen the looks on the agent's faces when I put it on in front of the manager, and a whole lot of '!!OVERDUE!!' warnings appeared. Classic:o) Thanks a lot Nikki, much appreciated!
Tim -----Original Message----- From: Nikki Peterson - ITCX [mailto:[EMAIL PROTECTED]] Sent: 06 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",[Received],No w()) & " day(s)",DateDiff("h",[Received],Now()) & " hr(s)"))) This will give you the age 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 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. Does anyone know how to conditionally format either all items received in the last hour, or all items over 1 hour old? Failing this, can anyone think of an alternative way of notifying them after an email passes it's contracted response time? I know this is per-user, but that's not an issue for me - I only set it up, whether they get fed up and turn it off isn't my problem. TIA for any help! Tim List Charter and FAQ at: http://www.sunbelt-software.com/exchange_list_charter.htm List Charter and FAQ at: http://www.sunbelt-software.com/exchange_list_charter.htm List Charter and FAQ at: http://www.sunbelt-software.com/exchange_list_charter.htm
