Revit MEP

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

Color fill Schemes

457 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: 455
Registered: ‎06-16-2010
Message 2 of 6 (444 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: 755
Registered: ‎08-10-2009
Message 3 of 6 (437 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: 2,951
Registered: ‎08-28-2009
Message 4 of 6 (435 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: 755
Registered: ‎08-10-2009
Message 5 of 6 (427 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 (404 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

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Are you interested in helping shape the Autodesk Community?
We’re looking at a few different ways to improve the “All Forums” landing page and need your feedback! If interested, please take a few minutes to fill out the following Usability Study. Thank you for your time!

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community

Revit Exchange Apps

Created by the community for the community, Autodesk Exchange Apps for Revit helps you achieve greater speed, accuracy, and automation from concept to manufacturing.

Connect with Revit