View Full Version : project 2000 vba for "Red" font


y7c4g2k5
01-27-2006, 06:17 PM
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

Rod Gill
01-27-2006, 09:11 PM
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" <y7c4g2k5.22b2no@DoNotSpam.com> 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
>