TeachUcomp, Inc.

P: 877-925-8080

  • HOME
  • VIDEO COURSES
    • All-Access Subscriptions
    • Business Licensing
    • Course List
      • Adobe
        • Acrobat
        • Lightroom Classic
        • Photoshop
        • Photoshop Elements
      • Crystal Reports
      • Employment Skills
        • Interview Skills
        • Resume Skills
      • For Lawyers
        • Excel for Lawyers
        • Outlook for Lawyers
        • QuickBooks for Lawyers
        • Word for Lawyers
      • HTML
      • JavaScript
      • Microsoft Office
        • Access
        • Excel
        • Microsoft Office Suite
        • OneNote
        • Outlook
        • Outlook on the Web
        • PowerPoint
        • Publisher
        • Word
      • Microsoft Project
      • Microsoft Teams
      • QuickBooks Online
      • QuickBooks Pro
      • Sage
        • Peachtree
        • Sage 50
      • SQL
      • Windows
    • Video Course Options
  • SUBSCRIPTIONS
  • MANUALS
    • Adobe
      • Acrobat
      • Lightroom Classic
      • Photoshop
      • Photoshop Elements
    • Crystal Reports
    • For Lawyers
      • Excel for Lawyers
      • Outlook for Lawyers
      • QuickBooks for Lawyers
      • Word for Lawyers
    • HTML
    • JavaScript
    • Microsoft Office
      • Access
      • Excel
      • OneNote
      • Outlook
      • Outlook on the Web
      • PowerPoint
      • Publisher
      • Word
    • Microsoft Project
    • Microsoft Teams
    • QuickBooks Online
    • QuickBooks Pro
    • Sage
      • Peachtree
      • Sage 50
    • SQL
    • Windows
  • REFERENCE CARDS
    • Adobe
      • Acrobat DC
      • Lightroom Classic CC 2018
      • Photoshop 2021
      • Photoshop 2020
      • Photoshop CC 2018
      • Photoshop Elements 2022
      • Photoshop Elements 2021
      • Photoshop Elements 2020
      • Photoshop Elements 2019
      • Photoshop Elements 2018
      • Photoshop Elements 15
    • Google
      • Google Classroom for Teachers
      • Google Docs
      • Google Drive
      • Google Forms
      • Google Sheets
      • Google Slides
    • Microsoft Office
      • Microsoft Office 365
        • Access for Office 365
        • Excel for Office 365
        • Microsoft Office 365
        • Outlook for Office 365
        • PowerPoint for Office 365
        • Publisher for Office 365
        • Word for Office 365
      • Microsoft Office 2021
        • Access 2021
        • Excel 2021
        • Microsoft Office 2021
        • Outlook 2021
        • PowerPoint 2021
        • Publisher 2021
        • Word 2021
      • Microsoft Office 2019
        • Access 2019
        • Excel 2019
        • Microsoft Office 2019
        • Outlook 2019
        • PowerPoint 2019
        • Publisher 2019
        • Word 2019
      • Microsoft Office 2016
        • Access 2016
        • Excel 2016
        • Microsoft Office 2016
        • OneNote 2016
        • Outlook 2016
        • PowerPoint 2016
        • Publisher 2016
        • Word 2016
      • Microsoft Office 2013
        • Excel 2013
        • Microsoft Office 2013
        • OneNote 2013
        • Outlook 2013
        • PowerPoint 2013
        • Word 2013
      • Microsoft Office for iPad
        • Microsoft Office for iPad
    • Microsoft Teams
      • Microsoft Teams
    • QuickBooks Online
      • QuickBooks Online
    • QuickBooks Pro
      • QuickBooks Pro 2022
      • QuickBooks Pro 2021
      • QuickBooks Pro 2020
      • QuickBooks Pro 2019
      • QuickBooks Pro 2018
      • QuickBooks Pro 2017
      • QuickBooks Pro 2016
      • QuickBooks Pro 2015
      • QuickBooks Pro 2014
    • Sage
      • Sage 50 2019
      • Sage 50 2018
    • SQL
      • SQL
    • Windows
      • Windows 11
      • Windows 10
  • STICKERS
    • Chrome OS
      • Chrome OS for Chromebooks
    • Mac OS
      • Mac OS Monterey-Mojave
    • Microsoft Office
      • Excel and Word 2021-2016 and 365
    • QuickBooks Desktop
      • QuickBooks Desktop 2022-2015
    • Windows
      • Windows 11 and 10
  • SUPPORT
    • Company
      • About Us
      • Blog
      • Contact Us
      • Our History
      • Our Philosophy
        • Customer Service
        • Mission
      • Policies
      • Testimonials
    • Contact Us
    • FAQ
    • Help
    • Lost Password
    • Register a Product
  • LOGIN
    • Manage My Account
    • Member Login
    • My Courses
  • CART
Shop Now

Advanced Formatting in Crystal Reports 2011- The Highlighting Expert

by Keeley Byrnes / Friday, November 15 2013 / Published in Crystal Reports, Latest

The Highlighting Expert

The Highlighting Expert is a tool which allows you to apply a specified formatting to a field when it meets a criteria which you set. For example, you could change the color of the font used to display numbers in a field to red only if they display a negative value.

To use the Highlighting Expert within a report, first select the field to which you wish to apply the conditional formatting. Next, click the “Highlighting Expert” button in the Experts toolbar or choose “Format| Highlighting Expert…” from the Menu Bar to launch the “Highlighting Expert” dialog box.

In this dialog box, you can click the “New” button to create a new item in the item list, which is displayed at the left side of the “Highlighting Expert” dialog box. To the right side of this dialog box, in the “Item editor” section, is where you can create and edit the formula used to apply the desired formatting.

Use the “Value of:” drop-down to select the name of the field whose value you wish to use as the basis of the condition you are about to specify. Note that you can select a field to format, but base the formatting upon the value of another field, which you can specify here. Use the drop-down below the first drop-down to specify the comparison operator used for the condition. The third drop-down allows you to specify a value from the selected field. This drop-down shows the first few hundred possible choices from the selected field. You can also type a value directly into the field itself, if needed. Notice that as you make or enter your choices from the drop-down menus available that the condition displays itself in the “Item list” at the left side of this dialog box.

Next you need to choose the formatting to apply to the selected field when the criteria which you specified is met. You can use the “Font style:” drop-down to choose a selected font style for the displayed used. The “Font color:” drop-down allows you to select from a basic set of color choices. Note that you can select the “Custom” color choice to launch the “Color” dialog box, where you can set your own custom color choice. You can use the “Background:” drop-down to accomplish the same thing by choosing the desired background color used for the display of the value. You can use the “Border:” drop-down to select the type of border to apply to the selected values when they meet the condition that you specify from this drop-down. After you have made all of the choices that you would like, you will be able to see the way that the text values will display in the “Sample:” text box.

At this point, you can then create additional conditions to which you would like to apply formatting to the same selected field by simply clicking the “New” button again and then repeating the same process of selecting the values and the formatting to display. If you have a condition specified for a field which you no longer wish to apply, you can select the condition to remove from the “Item list” and then click the “Remove” button at the bottom of the “Item list.” If you have multiple conditional formatting formulas listed in the “Item list,” you can click the “up” and “down” arrows to the right of the “Item list” to reorganize the order in which the conditional formatting will be enforced. When you have finished specifying any conditional formatting choices that you wish, you can click the “OK” button at the bottom of the “Highlighting Expert” dialog box to apply the selected conditions to the chosen field.

 

 

 

 

Tagged under: 2011, crystal, crystal reports, formatting, help, hightlight, hightlighting expert, how-to, training, tutorial

About Keeley Byrnes

Keeley is our Director of Marketing and has been with TeachUcomp since 2010. Keeley manages all aspects of our Marketing Department, acts as liaison for our reseller and affiliate partners and also authors courses in software and taxation.

What you can read next

How to Insert Bullets in Excel 2013- Microsoft Office Training
Freeze Panes in Excel - Instructions: A picture of a user selecting the Freeze Panes button in Excel.
Freeze Panes in Excel – Instructions and Video Lesson
View Side by Side in Word - Instructions and Video Lesson: A picture of a user comparing two documents side by side in Word.
View Side by Side in Word – Instructions and Video Lesson

 

Recent Posts

  • A picture showing how to use comments in HTML code.

    Comments in HTML – Instructions

    Overview of How to Add Comments in HTML        ...
  • A picture showing how to use the Pre tag in HTML.

    Pre Tag in HTML – Instructions

    Overview of How to Use the Pre Tag in HTML     ...
  • A picture showing the Start Personalization settings that let you customize the Start menu in Windows 11.

    How to Customize the Start Menu in Windows 11 – Instructions

    Overview of How to Customize the Start Menu in ...

Categories

Archives

  • GET SOCIAL

© 2001-2022 Copyright TeachUcomp, Inc. All rights reserved.

TOP
Sale! $49 All-Access 0 Days 5 Hours 57 Minutes 49 Seconds      $199 $49 Entire Library!
See Deal