Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Visio colors

Status
Not open for further replies.

jeberthold

Technical User
Apr 21, 2003
1
US


I am programming an event driven color change Visio 2002's Fill Format section of the Shape Sheet with the formula

=IF(DATEVALUE(Prop.NEXTINSP5)<DATEVALUE(NOW())+7 ed.,2,5)

in the FillForegnd cell, where 2 is the color to change to and 5 is the normal color.

I can specify color by number (0 to 23), but can't specify a custom color beyond 23. Is there a way to specify a custom color?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top