Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / June 2005

Tip: Looking for answers? Try searching our database.

Formula to change color of field

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Janie - 22 Jun 2005 22:28 GMT
I am trying to create a field that will change colors when certain rules apply.
For instance, we have certain process steps.  If a process step hasn't been
completed within 15 days of the due date, the field should be red.  If it
hasn't been completed within 30 days, the field should be yellow.  Otherwise,
field should be green.  Any ideas?
Scott L. Heim [MSFT] - 22 Jun 2005 22:32 GMT
Hi Janie,

Have you looked at the Conditional Formatting option? This should give you
what you desire.

Best regards,

Scott L. Heim
Microsoft Developer Support

This posting is provided "AS IS" with no warranties, and confers no rights
Janie - 22 Jun 2005 22:47 GMT
YOU are a genius!

> Hi Janie,
>
[quoted text clipped - 7 lines]
>
> This posting is provided "AS IS" with no warranties, and confers no rights
Janie - 23 Jun 2005 15:02 GMT
Okay, conditional formatting is what I want, but I have no idea how to build
the expression I need.

> Hi Janie,
>
[quoted text clipped - 7 lines]
>
> This posting is provided "AS IS" with no warranties, and confers no rights
Anton L - 23 Jun 2005 16:39 GMT
Try searching the forums for the infopath date calculations.
Janie - 23 Jun 2005 19:31 GMT
I went to the Infopath blog, but since I have never written code of any kind,
I'm kind of lost.  I'll keep trying to decipher it, but any other help is
appreciated.  Thanks!

> Try searching the forums for the infopath date calculations.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.