Jump to content
Mike T

Conditional Formatting within worksheets

Recommended Posts

Is it possible to use conditional formatting on worksheets?

 

Example 1: If a cell in a line meets a certain criteria I want the line to be highlighted blue

Example 2: If a Boolean value is true, I want the text to be bold

Example 3: If a record format number value exceeds a specific set amount, it is highlighted in red

Share this post


Link to post

Conditional formatting in the traditional Excel version is nor available in VW Worksheets.

 

I thought I had worked out a way to put colors in a single cell of a row based on a value, but I can't find that example right now.In my most recent attempt, it appears that you can not use an Image function inside an IF function in a worksheet.

 

There does not appear to be a way to format a single subrow of a database differently than all of the other rows.

 

I do have a way using a customer WSScript procedure to set a cell in a database row to a color based on some value directly accessible from the object. In my test, I used a record format attached to the object. If the first record attached to the object was named "A" it would put in an image of a rectangle in the drawing named 'Red'. If the first record was named "B" it would return and image of an object in the drawing named 'Blue'.

 

If this would be of any interest to you, I can try to polish it up. Tell me more about what type of conditional formatting you are trying to do and why and I will see what I can do to help.

 

 

 

 

Share this post


Link to post

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

 

7150 Riverwood Drive, Columbia, Maryland 21046, USA   |   Contact Us:   410-290-5114

 

© 2018 Vectorworks, Inc. All Rights Reserved. Vectorworks, Inc. is part of the Nemetschek Group.

×