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.
Same issue reported by German customer, Raimund Herbst at Dipl.Ing Denis Fink.
Anonymous
04-26-201710:15 PM
04-26-201710:15 PM
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.
Anonymous
05-09-201702:00 AM
05-09-201702:00 AM
That will be very usefull.
Anonymous
02-13-201809:31 AM
02-13-201809:31 AM
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.
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...
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.
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.
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..
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.
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.
How is this still not a thing? Even the wording in the conditional formatting dialogue indicates that you should be able to have multiple conditions... come on dev team, this must surely be an easy win??
It is crazy how in Revit 2022, you can't still add multiple conditions to highlight different elements in the schedules. I have multiple room types that need to be color coded according to the floor plan color scheme and is not possible.
Why so impatient everyone? It's only been six years. Writing software is hard and Autodesk has limited resources and money ... actually no, wait, they are a huge software company with high profit.
But seriously, I don't think they should fiddle with these conditional behaviour systems one at a time. I hope they are working quietly to bring one unified system to the many parts of Revit where some conditions are possible. The Filter system for "Filters" is pretty good. But it's a different one for Conditional Formatting, and other possibilities in Calculated Formulas. A unified system would be great.
Here was my work around for a quasi if/then statement. I shade the column "green" to start. (if). Then my test turns my condition to "red" and this overrides.