Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-10-2012, 09:19 PM
meileetan meileetan is offline Change font colour when tasks are completed Windows Vista Change font colour when tasks are completed Office 2007
Novice
Change font colour when tasks are completed
 
Join Date: Aug 2012
Posts: 16
meileetan is on a distinguished road
Default Change font colour when tasks are completed

How can I format text styles for tasks that are completed (100%)?
Reply With Quote
  #2  
Old 09-11-2012, 02:31 PM
JulieS JulieS is offline Change font colour when tasks are completed Windows 7 64bit Change font colour when tasks are completed Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

I'm afraid only through VBA code could you accomplish this. You can easily change Gantt bars to reflect whether a task is complete - but font faces are only changed either through styles or code.

Usually the code sets the task's Marked field to "yes" and then uses the font styles formatting for marked tasks to change the color. The down side is that you have to remember to run the macro regularly.

I hope this helps.
Julie
Reply With Quote
  #3  
Old 09-11-2012, 07:19 PM
meileetan meileetan is offline Change font colour when tasks are completed Windows Vista Change font colour when tasks are completed Office 2007
Novice
Change font colour when tasks are completed
 
Join Date: Aug 2012
Posts: 16
meileetan is on a distinguished road
Default

Thanks Julie. Coding is not for me so I will play around with the Gantt bars as you suggested.
Reply With Quote
  #4  
Old 09-12-2012, 07:09 AM
JulieS JulieS is offline Change font colour when tasks are completed Windows 7 64bit Change font colour when tasks are completed Office 2010 32bit
Expert
 
Join Date: Dec 2011
Location: New England
Posts: 1,693
JulieS will become famous soon enough
Default

You're very welcome and thanks for the feedback. Feel free to post back if you have further questions.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
updating not completed tasks or 0% tasks ketanco Project 3 08-24-2012 05:59 AM
Change font size of tasks in pane under Calendar ghumdinger Outlook 2 08-16-2011 06:29 PM
Outlook completed tasks synced with Windows Mobile 6.5 ghumdinger Outlook 0 07-03-2011 07:22 AM
Font Size & Colour yparuk PowerPoint 0 10-07-2010 12:37 AM
font colour problems darro Outlook 0 11-25-2009 03:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:40 AM.


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