Revit MEP

Distinguished Mentor
Posts: 769
Registered: ‎08-10-2009
Message 1 of 6 (527 Views)

Color fill Schemes

527 Views, 5 Replies
05-14-2012 12:43 PM

I have a "Calculated Value" in a schedule I use.  It is called "Room Pressurization".  Some values are +CFM, some are -CFM.  Since I cannot use the conditional formatting for both positive and negative values (one color for positive, another color for negative) in the schedule, I tried to do a "Color Scheme".  Now, I cannot create that same Calculated value.


Any suggestions?

Valued Mentor
Posts: 458
Registered: ‎06-16-2010
Message 2 of 6 (514 Views)

Re: Color fill Schemes

05-15-2012 05:12 AM in reply to: asommer

Could you not just live with a single colour conditional format - if CFM<0 is red otherwise positive values are white?

If my reply answers your query, please use the Accept as Solution.
Please give Kudos as appropriate to enhance the value of these forums.

Thank you!
Distinguished Mentor
Posts: 769
Registered: ‎08-10-2009
Message 3 of 6 (507 Views)

Re: Color fill Schemes

05-15-2012 07:09 AM in reply to: asommer

My Room Pressurization Calc is a "Calculated Value" in one of my schedules.  It does not show up as a useable parameter in the Color Schemes.  It is "Actual Supply Airflow - Actual Exhaust Airflow" (there is no Return on this project).  I also want to use multiple colors in negative and positive pressures.

*Expert Elite*
Posts: 3,289
Registered: ‎08-28-2009
Message 4 of 6 (505 Views)

Re: Color fill Schemes

05-15-2012 07:32 AM in reply to: asommer

Calculated Values do not leave the schedule. You can only add Project/Shared Parameters to the color scheme and you cannot apply formulas to those, so you're kinda S.O.L.


The only way you could do that is with manual work - add the Project Parameter to the Color Scheme and to your schedule and manually match the values. You can create an conditional format in the schedule to highlight the lines where the Calculated value does not equal the Project Parameter's value, but this cannot be an automated function.

Corey D.                                                                                                                  ADSK_Logo_EE_2013.png    AutoCAD 2014 User  Revit 2014 User
⁞|⁞ Please use Mark Solutions!.Accept as Solution and Give Kudos!Give Kudos as appropriate to further enhance these forums. Thank you!
Distinguished Mentor
Posts: 769
Registered: ‎08-10-2009
Message 5 of 6 (497 Views)

Re: Color fill Schemes

05-15-2012 07:56 AM in reply to: asommer

Yeah, I kinda figured that.  I could do a Positive and Negative pressurization Calc. Value, But I really want to display this on a Floor plan to see what's going on as far as adjacent rooms.  Thanks for the Info, anyway.

Posts: 3
Registered: ‎05-17-2012
Message 6 of 6 (474 Views)

Re: Color fill Schemes

05-17-2012 07:17 PM in reply to: asommer

Can I just add, this is an astonishing failure. When I first found out that Revit could do colour fill schedules based on parameters, I was over the moon - all our engineers could produce easy to read reports based on ACH/hour, CFM, positive / negative pressurization, the works! This would revolutionize how our company operates.  All our engineering data could be stored in the space and we could access it and view it however we liked.


Then I found out that you can't add calculated parameters, so as far as we're concerned, the colour fill legends are pretty much useless, and by proxy so is much of the engineering functionality.


I hope there's a plan in the works to change this because I have never felt so frustrated with Revit in my life when I discovered this

Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.