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

Hi Pat!


Apologies for resurrecting this old thread but it was the first one I found on the subject. I'm looking to highlight cells in a database that are value of 0 for instance. Is this possible in your (albeit very dated) example?



Share this post

Link to post

Nothing has changed about "conditional formatting" since the original post in 2017.  Still a very hard thing to do. 


How much do you need this?

Share this post

Link to post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


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.

  • Create New...