Color alerts are also referred to as calculated colors, and they are useful for business users. Color alerts can be coded in the chart (or other) object and are commonly used to change the fonts or background colors of table cells, lines, and bars in charts. Calculated colors can also be used for navigation, to show users what the current tab is:
The preceding code sets colors as follows: if the sheet (tab) is named
SH01, the color of the text or object is the color as set in the
vColor1 variable, and if the active sheet is not
SH01, the text or object is the color as set in the variable
if(GetActiveSheetId()='Document\SH01',Color (1), Color ...