Testing on task's font color

[Marguerite]

I am currently working on a program with 6 project managers. There is one
plan (which I inherited). The PM's make a local copy and color the tasks:
Blue for change, Red for delete, Purple for add.

I want to automate the update to the master, by reading through the colored
copy, but I cannot determine how to test on the task's font color
programmatically.

Any help is greatly appreciated.

 

[JackD]

Sorry, The color is write-only. You can set the color using VBA but you can
NOT read it.
Why not add a text field and have them choose a value for any changes?
It is much more reliable and will even work for people who are colorblind or
when you print out in black and white.
You can then write a macro to format the color based on the value they have
chosen.

 

[Marguerite]

Excellent suggestion, Jack. Thanks!

 

[dbonline]

I have a similar situation as Marguerite. I have not been able to train my
users to update the flag field each time the modify the data, but they are
pretty consistent in changing the font color for the values they change.
Since I can't read the font color, is there a way to automatically update a
flag field when a user changes the font color or modifies the value in
specific fields for a task?

Thanks.

 

[Jack Dahlgren]

I'd have them set a baseline before they make any changes, Then you can
check any variance against baseline.

-Jack Dahlgren