ISTHEMED Function

Office 2013 and later

Last modified: March 09, 2015

Applies to: Office 2013 | Visio 2013

In this article
Version Information
Syntax
Return Value
Remarks
Example

Returns a Boolean value indicating whether a shape has a theme applied to it.

Version Added: Visio 2013

ISTHEMED()

Note 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.

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.

Show: