Schedule Conditional Formatting

,
1

Hi community,

I would love to be able to add multiple rows of conditional formatting (shading) to a revit schedule depending on what the cell contents are.

i.e. if cell contents = A1, Shade Red, = A2, Shade Green, = A3, Shade Blue, Else no shading.

I have looked at a few different external packages and the likes but cannot find anything appropriate. Has anyone tackled this problem?

Thanks

2

Hello @HaydenWright and welcome to the forum…try take a look into archilab there some nodes for schedules, not sure if you can format cells that way, but try take a look

3

Thanks for the reply @sovitek !

Unfortunately I have already been down that path. From what I can see, the archilab nodes relate to conditional formatting in excel schedules, not Revit schedules.

1 Like
4

allright, try take a look here…Fill color of a cell in a schedule

but you can do it if you export to excel…and then use bumbleebe…Formatting multiple ranges on multiple sheets in excel with Bumblebee BB style

2 Likes
5

Thanks mate. Looks like it’s not possible to do within Revit/Dyn exclusively like I had hoped.

6

@solamour, @jacob.small do you know if these functionalities are in the roadmap?

7

How would you do this in native Revit, without Dynamo?

8

I believe this is what he is trying to achieve.

9

Correct, but multiple conditional formatting options to each row of the Revit schedule

10

Row was my hang up. I do not believe this feature will do rows - only fields in a column, or at least not that I have seen. I also do not believe that conditional formatting API is exposed. Assuming both are true this is a wishlist item for first Revit and then Revit API.

You could try applying this: SetCellStyleOverrideOptions Method

However I do not believe that overrides apply to standard schedules.

11

(Warning: Probably not a good idea but maybe worth trying just for fun…)

You could try mapping schedule values to sheet schedule locations and place color-coded “fill regions” to replicate the conditional formatting feature. Unfortunately, sheets don’t allow fill regions, so you’d have to translate this to a view first which will make things even messier. Or you could draw detail lines directly on the sheet as a hatch pattern. Neither one of these is a particularly “good” solution and would be heavily reliant on your schedule formatting and change management but they are technically options.

2 Likes
12

Not even in the top 10 list of messy things I have seen in Revit today, so I say go for it.

4 Likes
13

Hi @jacob.small, had a play with the SetCellStyle… almost there but as you pointed out, it only works on a per column basis.

What is the process for wishlisting this feature as I think exposing conditional formatting or individual cell style to the API would be valuable.

14

Before it can be added to the API it needs to be added to the application; often (usually) the API will follow, but it is two separate asks.

To get the first you need to post to the Revit Ideas forum.

Some things to keep in mind when making a feature request for any tool:

  1. Make a business case for why a majority of users would benefit from this change, or why new users would adopt the platform by adding the feature. Remove your singular context from the language and speak on behalf of EVERYONE who might ever use the tool.
  2. Put value metrics ($, hours, etc.) into the post if you can, as accurate metrics are indisputable and help justify effort ($) to build the feature as it suddenly is easier to sell.
  3. The level of difficulty to produce and maintain a feature, staff availability, and other proposals will be taken into account when trying to decide what features to build; a full overhaul is more expensive than a slight tweak and therefore less likely to be undertaken.
  4. Think about the impact on other users in other industries before you submit. If the feature will break another aspect of the tool it is less likely to progress than a feature that has no impact or positive impact to other users.
  5. The level of effort to build a feature is multiple orders of magnitude more than what you likely think it is, and some things will take years worth of releases to be successfully released.
  6. Disruptive ideas are viewed differently as they open the doors for more business.
  7. Decision makers often only know what you tell them - be clear and communicate with common language and illustrations when possible.

So with that in mind, here is a generic review of posts to consider.
Bad: Our firm always did it this way in the old tool.
Ok: Teams would be able to add emphasis to convey intent.
Good: Firms would be able to spot QA issues instantly which will reduce rework while saving an estimated 4 hours of review time and providing better outcomes downstream by more clearly indicating design intent.

3 Likes