TeachUcomp, Inc.

 MY CART
  • VIDEO COURSES
    • All-Access Subscriptions
    • Business Licensing
    • Course List
      • Accounting
      • 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
      • Lightroom Classic
      • Photoshop
      • Photoshop Elements 2023
      • 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
    • Mac OS
      • Mac OS Ventura-Mojave Keyboard Shortcuts
    • Microsoft Office
      • Excel Keyboard Shortcuts
      • 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 2023
      • 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 11 and 10 Keyboard Shortcuts
      • Windows 10
  • STICKERS
    • Chrome OS
      • Chrome OS for Chromebooks
    • Mac OS
      • Mac OS Ventura
      • Mac OS Monterey-Mojave
    • Microsoft Office
      • Word and Excel (Mac) 2022
      • Word and Excel (PC/Windows) 2021-2016 and 365
    • QuickBooks Desktop
      • QuickBooks Desktop (PC/Windows) 2023
      • QuickBooks Desktop (PC/Windows) 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
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

Workbook Protection in Excel- Instructions: A picture of the “Protect Structure and Windows” dialog box that is used to apply workbook protection in Excel.
Workbook Protection in Excel- Instructions
Create Headers and Footers in Excel - Instructions: A picture of the “Header” dialog box you can open from the “Page Setup” dialog box in Excel.
Create Headers and Footers in Excel – Instructions
A picture of the
Booting to the Desktop at Startup in Windows 8.1

 

Recent Posts

  • A picture of a user applying the Paint Bucket Tool in Photoshop Elements.

    The Paint Bucket Tool in Photoshop Elements- Instructions

    Overview of How to Use the Paint Bucket Tool in...
  • A picture of highlights applied by the Recompose Tool in Photoshop Elements, showing areas to remove and protect in a photo.

    The Recompose Tool in Photoshop Elements – Instructions

    Overview of How to Use the Recompose Tool in Ph...
  • A picture showing how to import files to the Organizer in Photoshop Elements by using the “Get Photos and Videos from Files and Folders” dialog box.

    Import Files to the Organizer in Photoshop Elements – Instructions

    Overview of How to Import Files to the Organize...

Categories

Archives

  • GET SOCIAL

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

TOP
Go to mobile version
Sale! $49 All-Access 0 Days 21 Hours 18 Minutes 51 Seconds      $199 $49 Entire Library!
See Deal