Hi,
Is there a way in Revit2020.1 to use conditional formatting to highlight in any color when a length is over a specified value? For instance, we have a line family we use for egress and a schedule that reads the length of the run. Some areas require different allowable distances (200’ in some cases, 150’ in others, etc.). I want the schedule to highlight cells that are over the specified limit. I created some combined parameters and allowable max parameters, but in the conditional format window, I can only specify a value and not assign the value of a parameter as the conditional element. The screenshot below shows that both cells are highlighted even though one of them does not reach the 200’ max.
I could attain the results I want if I have multiple schedules, one for each max distance allowed, but this is not ideal if I can avoid. Any thoughts?
Thanks
Screenshot below. the value is set to 0", which I know is the reason why both cells are highlighted, but the issue is that, yes, I can change it to 200', but for those egress path that need a different max distance, i'm screwed if I want to use the same schedule.
Attached is an example. I used a wall schedule because I am on 2019.
Maybe highlighting isn't the best approach then. Does it need to formatted this way?
no, it doesn't have to be formatted this way. we have been doing it by simply having the path ID, the actual travel distance (read from the line family), and the allowable distance headers in the schedule (we just type what the max distance is for each row). I just got curious and wanted to see if there was a way to automatically highlight if we go over the max allowed distance to be able to catch it real quick by looking at the schedule, but we can just keep doing this. this was a personal task i had, not really my firm asking me if I can do it.
If I want to highlight the existing doors to remain in a schedule, how to conditional format with "Phase Created" as the parameter?
@VelaWang wrote:
If I want to highlight the existing doors to remain in a schedule, how to conditional format with "Phase Created" as the parameter?
Since Phasing cannot be used for conditional formatting, use some workaround such as enter a value to Comments for all Existing to remain doors, then use Comments field for conditional formatting.
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.