Font Color

[Paul]

Does anyone know how to retrieve the font color from a
task name cell? The status of tasks are being indicated by
color and I need to determine this status. I've checked
font related properties in the automation without much
luck and finding documentation in this area has been
difficult.

Anyone?? ;o)

 

[John]

Paul,
Unfortunately VBA can manupilate the font characteristics but cannot
"read" them. You mention that the status is being indicated by color.
There may be other attributes that can detect status depending on what
you define as "status". How is the font color being set in the first
place? If it is being manually set, the criteria that is being used can
perhaps also be used by VBA code. If the color is being automatically
set by VBA code then you already have the means to detect "status".

John

 

[Paul]

Unfortunately the colors have been set manually over the
years and there are literally thousands of them. It will
not be viable to have these changed for this purpose.

Thanks for the reply.

 

[John]

Paul,
You may be right about there being "thousands" but at least it is
limited to "7500" if that is any consolation. However, now that you know
the colors can't be decoded through VBA, if you still want to determine
the status a new approach is required. Do you have any idea as to what
criteria was used to set the colors? What is the end goal? With a little
head scratching or plain blind luck, we can help you come up with a
scheme to solve the problem.

By the way, how many different colors are used? How many tasks in the
file? Is it a single file or master file with inserted projects?
John

 

[Paul]

I mean there are thousands of seperate project worksheets,
there is no limit. These have been created by field
engineers on oil rigs. There are only 4 colors that
represent the status of a particular job. As it turns out,
trying to access colors is a pointless effort as I've
since discovered that different shades of these colors are
being used. I've crafted some rules from the data in
project database that can give me the status of most of
the jobs, but the overuling factor is still the color.

I'm contacting Microsft for support in this matter as it
is vital for the success of this thing.

Tanks for your efforts.

 

[John]

Paul,
OK, now I understand, you are definitely having fun. Good luck with the
MS support approach.

John