Recently, a few customers asked me how to bypass color fills when a Sticky is linked into Revit. Some customers prefer color fills in their Excel files, but when color isn’t preferred in the final documentation, they need the fills omitted when the files are linked into Revit.
By default, if a cell is filled with a color, Ideate Sticky will carryforward that color along with text that is formatted with a color, except when a text string has a hybrid of colors. But there are two ways to have that fill color omitted:
Give conditional formatting or cell pattern overrides a try and see if it works for your situation. If it does not, let us know, and we will have a look for you.
Shown here is a Plumbing Fixture Schedule in Excel (this file ships standard with Ideate Sticky) that was manually highlighted to show all the values that are zero. In this example, the cells were filled with a red stipple pattern.
Shown here is the Format Cells dialog box and the application of the red fill color and the stipple pattern style. The application of the fill pattern is a manual process, which means if a condition is met, you may want to change the fill pattern color and style back to white, if applicable.
Shown here is the resulting Sticky once it is linked into Revit. You can see there is no red stipple. Because the pattern style is a stipple, it is not recognized by Revit once it is linked via Ideate Sticky. The result is an omission of both the color and the pattern, which is what we wanted to achieve.
Shown here is a Plumbing Fixture Schedule in Excel (this file ships standard with Ideate Sticky) that was highlighted solid red to show all values that are zero, by using Conditional Formatting. If the condition no longer applies, Excel will automatically remove the fill color, because the conditional formatting is no longer met.
Shown here is the Edit Formatting Rule dialog box and the application of the red fill color. For this example, we want to highlight cells that have values less than or equal to zero. The application of the fill pattern is an automatic process if the condition is met. If the condition is not met, the cell will remain as is. Conditional formatting may be a better option, since the cell formatting becomes an automated process.
Shown here is the resulting Sticky once it is linked into Revit. You can see there is no red solid fill. Because the pattern style is defined with a Conditional Format, the conditional formatting formula is not recognized by Revit once it linked in via Ideate Sticky. The result is an omission of the color and fill, which is what we wanted to achieve.
Services
Products
Contact Us
Thank you for contacting us.
We will get back to you as soon as possible
Ideate Software
Oops, there was an error sending your message.
Please try again later
Ideate Software
All Rights Reserved | Ideate Software Privacy Policy Data Processing Agreement Data Security Policies Terms of Use Site Map