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 biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional formatting

Status
Not open for further replies.

Henryk

MIS
May 14, 2004
12
GB
Hi,
I'm new to Visio and would like to use Excel-type conditional formatting for shapes, based on data passed from a spreadsheet. I came upon this thread which suggested that this is possible, but there is no explanation as how to achieve it.

thread172-1151333

Can anyone shed some light on this? I have seen that this functionality is available in Visio2007, but I'm limited to Visio2003.

The thread seems to suggest that VBA isn't required, but if it is neccesary, please advise.

Thanks,
H
 
faq222-2244 gives some guidance on forum usage, including research ideas. Google brought up
___________________________________________________________
If you want the best response to a question, please check out FAQ222-2244 first.
'If we're supposed to work in Hex, why have we only got A fingers?'
Drive a Steam Roller
Steam Engine Prints
 
The article in question involves placing
=Lookup(Prop.Status,"Black;White;Red;Green;Blue;Yellow")
in the cell for the colour. The cell expects a number ofr a colour and this formula will take the contentof Custom Property Status and convert it to a number by looking it up in the list of colours.

There are many ways of applying custom formatting within Visio, this just shows an example of basing the colour on a Custom Property.

John... Visio MVP - Visio.MVPs.org
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top