Return value for row color

[Dave]

I wrote a simple macro that checks the values of a list in a custom
text field and sets the color of the row based on the value of the
field. I was thinking that there are times when it would be handy to
be able to do the reverse - i.e., set the value of a custom field
based on what color the row is currently set to. Could someone please
tell me how to check and return a value for row color?

Thanks
Dave

 

[Jan De Messemaeker]

Hi,

Sorry, not possible. Fonts and colors are "Write Only".

--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
+32 495 300 620
For availability check:
http://users.online.be/prom-ade/Calendar.pdf

 

[Dave]

Interesting. Thanks for the quick response! No need to waste any
more time strainig my brain over that.

 

[Lars Hammarberg]

Check if ActiveCell.CellColor does for you.