Results 1 to 5 of 5
Like Tree13Likes
  • 10 Post By guitarchitect
  • 1 Post By tzframpton
  • 1 Post By sdbrownaia
  • 1 Post By mickymx

Thread: Schedules - Formatting (Bold totals!)

  1. #1
    Junior Member
    Join Date
    March 13, 2012
    Current Local Time
    07:43 AM

    Schedules - Formatting (Bold totals!)

    Given that I've been using Revit for so long and I didn't know it was possible, I thought it might help others who like a nicely formatted schedule. I apologize if this is common knowledge - I did revit training ages ago and I'm really due for a refresher. In any case:

    It always drove me nuts that I couldn't nicely format schedules in revit - bolded totals, clean lines, etc. You click on a cell, you can't change the text. You click on a header, you can change the text. The totals, you can't change. It leads to a lot of schedules that look like this:

    Now maybe that's fine in CD or for a massive + complicated door schedule, but for a simple schedule that you might be showing a client early in the design process, it's a bit clunky. What I discovered one day, somewhat by accident, was that if you select an entire column you can over-ride the text settings! When I realized that this didn't affect the Total text, I had a bit of a eureka moment: if I set the default schedule text to be the style I want for the totals (bold), I can just select all of the columns and over-ride the rest of the schedule to be normal text! Now, with some tweaks to the gridlines, it looks like this - a little better!

    (be sure to highlight your headers and reset them, otherwise they're overwritten too)

    After even more trial and error, and much frustration, I came to my final realization - when you select a column, the formatting box changes ever so slightly to be two rows rather than one. Select a bunch of columns, and it expands yet again:

    What this means is, you have a chance to change all of your row formatting! It's not immediately obvious, but if you select your linetype first and then click the border you want, you'll change the line type + weight of the schedule grid. It's deceptive, because it doesn't show lineweight. Your settings here apply to each section of the schedule that's separated by a total. In other words, the "bottom border" is the line right before the total, the middle border is the line after each schedule row, and the top border is the top border in the schedule. Additionally, if you really want a border to not show up, you have to turn it on and then off. If you have all of your columns highlighted at once, you have to ensure you get all of the settings at once. If you go back and change one column's setting, it'll over-ride everything and it's really annoying. A few tweaks later and now I have a presentation/graphic schedule that I can apply to anything:

    Perfect! A much nicer schedule for presentations, client packages, and things like quick massing studies where you want to see floor + area totals of conceptual masses. Of course, as is the nature of Revit, you can't save this as a template because of all the over-rides. So, get used to the process over over-riding the font and tweaking the borders.

    I feel stupid for not knowing this sooner, but Revit has never been the most user-friendly program. My hope is that by putting this here, others who are in the same situation will learn something. If you have any additional schedule formatting tips, please share!

    (This is for Revit 2016 and earlier - I haven't upgraded to 2017 yet so maybe some of this is fixed?)
    Attached Thumbnails Attached Thumbnails Schedules - Formatting (Bold totals!)-schedule_boring.png   Schedules - Formatting (Bold totals!)-schedule_lessboring.png   Schedules - Formatting (Bold totals!)-borders.png   Schedules - Formatting (Bold totals!)-schedule_graphic.png  

  2. #2
    Forum Addict tzframpton's Avatar
    Join Date
    January 17, 2011
    Dallas, TX
    Current Local Time
    05:43 AM
    Excellent write up, thanks for sharing!!

    guitarchitect likes this.

  3. #3
    Forum Addict sdbrownaia's Avatar
    Join Date
    December 20, 2010
    Current Local Time
    06:43 AM
    Absolutely beautiful!!!! been using revit tooo long not to know this.
    guitarchitect likes this.

  4. #4
    New Member
    Join Date
    January 6, 2017
    Current Local Time
    01:43 PM
    JUST WANT TO SAY : THANKkkkkkkksssssssssssssssssssssssssss
    guitarchitect likes this.

  5.    #5
    New Member
    Join Date
    December 14, 2018
    Current Local Time
    12:43 PM
    this is great, thanks!

Similar Threads

  1. Conditional Formatting for Calculated Totals
    By cellophane in forum Architecture and General Revit Questions
    Replies: 1
    Last Post: March 14th, 2016, 04:30 PM
  2. Node to read totals from schedules.
    By Revitaoist in forum Dynamo BIM
    Replies: 4
    Last Post: November 20th, 2015, 07:45 AM
  3. Revit OpEd: Text Formatting with Bold and Underline
    By Revit OpEd in forum Blog Feeds
    Replies: 0
    Last Post: February 14th, 2015, 04:15 PM
  4. Stack Formatting Schedules
    By billiam in forum Architecture and General Revit Questions
    Replies: 1
    Last Post: January 21st, 2015, 02:49 AM
  5. Formatting Window Schedules
    By Alan Roberts in forum Architecture and General Revit Questions
    Replies: 2
    Last Post: August 2nd, 2011, 02:03 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts