Announcements
Welcome to the Revit Ideas Board! Before posting, please read the helpful tips here. Thank you for your Ideas!
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Multiple Conditional Formatting

Multiple Conditional Formatting

In schedule conditional formatting, we should be able to use multiple conditions using the same field. (i.e. 0 fc = red, 1-20 fc = yellow, etc.) Currently to have multiple rules, you have to reference different fields.

Capture.JPG

 

39 Comments
Zsolt.Varga
Autodesk Support

Same issue reported by German customer, Raimund Herbst at Dipl.Ing Denis Fink.

Anonymous
Not applicable

Would be useful to apply multiple conditions and format a schedule cell in multiple colours. For example, if a value is greater than Parameter A, make it Red OR if it is less than Parameter B, make it Orange.

Tags (2)
Anonymous
Not applicable

That will be very usefull. 

Anonymous
Not applicable

This would be great. It would also be nice to easily apply a conditional format across a row instead of having to set the same conditional formatting for each column.

wezpb
Advocate

Would be very useful. Voted up!

Anonymous
Not applicable

Would be great to be able to use a View template on a schedule with rule based Filters stored to conditionally format consistently with a view. 

robert
Contributor

If conditional formatting allowed for formulas that would be extremely useful. I.E. I have a window that needs that I want to meet egress. The window has to be 5.7 sq ft. The formula would be something along these lines:

(Height x Width) >= 5.7, Choose specified color if not. 

or something like: 

or Family Type, "red" if Length< 48 , or Width < 36". 

basically using similar formulas that are available in excel or the Revit family editor; primarily, logic statements; if, and, or, etc...

Anonymous
Not applicable

Yes Please

filip.roels
Contributor

Would be very useful!

ngaraycocheaMLKJ9
Community Visitor

would be USEFUL!

Anonymous
Not applicable

Multiple conditional formatting would be useful. Is this in the works?

In my case, I am trying to color code departments in a Revit room schedule to match the color scheme used in corresponding room area plans. Have not found another way to do this. Maybe there is another way.

dtiemeyer
Advisor

This would be useful in MEP as well. If something is 'approaching critical' make it yellow, if it 'is critical' make it Red.

JustinJa6VT3N
Observer

I have also come across this limitation. Would be so amazing if we could have multiple coditions formated based on data in the schedule cell, even up to 10! Bummer.😑

antonvanderveer
Explorer

To me it's weird that this feature isn't in Revit. It kind of looks like they started writing the feature, tested if it workes with 1 condition, and never got back to it to finish it.

And comeon.. You don't have to implement Excel into Revit, but make it at least decent.. The software is pretty expensive, but not even close to polished yet..

nomaankhatri
Participant

Is Autodesk thinking about this?

zhaohui.chen5TEA7
Enthusiast

must have

alina_mcconnochie
Contributor

does this feature exist yet? 

why is it not possible to add formula's in here? 

can it be done with dynamo at least? 

the amount of times revit is missing basic functionality is infuriating!

 

antonvanderveer
Explorer

Technically speaking the "multi function" feature has been implemented (I work in Revit 2020.2), but looking at it from any other side, it is incomplete. I don't know when it was added; I accidentally stumbled on how it works.

 

Revit Example.png

 

When done setting up the condition, you can change the field (red arrow), set the test and value, and it is added to the "conditions to use" list. 
This feature cannot compare cells nor fields with each other, and you can "test" every field only once. A minimalistic feature, but it is something.

smurck
Contributor
It needs an if/then statement. If this then green cell, if that then red cell
Mario_LeRoux
Participant

We need more formatting and table manipulation options please.

My documentation is hampered by the Native Revit table formatting options

Can't find what you're looking for? Ask the community or share your knowledge.

Submit Idea  

Autodesk Design & Make Report