I need vba for filtering on the color red in various fields - "Start", "Finish", "% Complete", "Duration", and "Task Description". Thanking you in advance -- y7c4g2k5 ------------------------------------------------------------------------ y7c4g2k5's Profile: http://forums.techarena.in/member.php?userid=10274 View this thread: http://forums.techarena.in/showthread.php?t=449312 Free Computer Help - http://forums.techarena.in
I don't think you can read the color of a font. What you need to do is create a formula in a custom field where you calculate the color then filter on the custom field. Plenty of help in Project Help on custom fields and formulas. -- Rod Gill Project MVP Visit www.msproject-systems.com for Project Companion Tools and more "y7c4g2k5" wrote in message news:y7c4g2k5.22b2no@DoNotSpam.com... > > I need vba for filtering on the color red in various fields - "Start", > "Finish", "% Complete", "Duration", and "Task Description". Thanking > you in advance > > > -- > y7c4g2k5 > ------------------------------------------------------------------------ > y7c4g2k5's Profile: http://forums.techarena.in/member.php?userid=10274 > View this thread: http://forums.techarena.in/showthread.php?t=449312 > Free Computer Help - http://forums.techarena.in >