Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 10-08-2015, 03:39 PM
JulieS JulieS is offline A Formula Request Windows 7 64bit A Formula Request Office 2013
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

In a text field:



switch([% Complete]=100,"blue",ProjDateDiff([Current Date],[Finish])/[Minutes Per Day]<=5,"red",ProjDateDiff([Current Date],[Finish])/[Minutes Per Day]<=10,"amber",ProjDateDiff([Current Date],[Finish])/[Minutes Per Day]>10,"green")
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
A Formula Request Request for word VBA books Raza Word VBA 1 01-09-2015 04:10 AM
Formula Help Request OTPM Excel 16 12-16-2013 01:57 PM
A Formula Request Formula help request JAMS Excel 2 04-06-2012 10:14 PM
Outlook Calendar request steve42399 Outlook 2 04-12-2011 09:35 AM
Meeting Request - Another Organizer coolpeter86 Outlook 0 12-12-2010 11:58 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:21 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft