ISTHEMED Function
Returns a Boolean value indicating whether a shape has a theme applied to it.
Version Information
Version Added: Visio 2013
Syntax
ISTHEMED()
Return value
Boolean
Remarks
Note
The ISTHEMED function in Visio 2013 replaces the CELLISTHEMED function from previous versions of Visio.
The ISTHEMED function lets you assign appropriate parts of a theme's formatting to a shape but retain the ability to override other parts of the theme formatting with manually-applied formatting. If you subsequently reapply the theme, any manual formatting is overridden and the shape takes on all of the theme's formatting.
ISTHEMED evaluates to TRUE if the ColorSchemeIndex cell in the shape is greater than 0. If this cell is equal to 0, then ISTHEMED evaluates to FALSE. The theme of the DocumentSheet and PageSheet won't affect the value of the ISTHEMED function used in a ShapeSheet. Only if the ISTHEMED function shows up in the PageSheet does the page's theme matter.
Example
Cell |
Formula |
Result |
---|---|---|
Char.Font |
IF(ISTHEMED(), THEMEVAL(), FONT("Calibri")) |
If the shape has a themed applied to it, the shape text accepts the font formatting from the theme. If the shape is not themed, the shape text is formatted with the "Calibri" font. |
LineColor |
IF(ISTHEMED, RGB(255, 0, 0), RGB(0, 255, 0)) |
If the shape has a themed applied to it, the shape's line color is red. If the shape is not themed, the shape's line color is green. |