Formatting Sheet Index Worksheet when attached to Title Block

[greentea]

Hi,

We have a Sheet Index Worksheet that is attached to our Title Block Border and related Sheet Numbers and Sheet Names.  On the Sheet Index itself, I wanted to see if there is a way to edit only a few rows of the Sheet Index.  For example, the Civil Sheets C1.0-C3.0.  The grading is sometimes under a separate permit, so we'd like to differentiate these sheets somehow by making the text italic.  When I try to edit the formating of an individual Sheet name cell however, it changes the formatting of all Sheet names to be italic.  Please see screenshots attached.  Does anyone know how I could format only the C Sheets to be italic, and the rest of the sheets's formatting to remain?  Thanks in advance!

[Nikolay Zhelyazkov]

Hello @greentea,

 

Unfortunately, I think that this is a limitation of the database worksheets and there is no way to set the font for the separate subrows.

 

Best Regards,

Nikolay Zhelyazkov

[twk]

You could split your sheet index into multiple database header rows.

Eg

First Database Header Row's criteria = All Titleblocks AND TitleBlock.SheetName contains "T" -- No Formatting

Next Database Header Row's criteria (the one for Civil) = All Titleblocks AND TitleBlock.SheetName contains "C" -- Text Formatting : Italic

and so on..

[Pat Stanford]

Another (albeit more manual) alternative is to pick a different way to indicate the drawings that you want highlighted. While you can't do it within the worksheet.

 

Put the worksheet on the drawing and draw a rectangle over the cells you want highlighted and give it a fill or a pattern and a low opacity.

 

Put the worksheet on the drawing and give it a Fill of None. Then draw a rectangle over the cells you want and give it a fill or pattern and Send to Back.

 

Just thinking outside the box.