O'Reilly logo

Oracle Business Intelligence: The Condensed Guide to Analysis and Reporting by Yuli Vasiliev

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Conditional formatting

When you deal with a lot of data on your worksheet, it's always a good idea to highlight some data to make the entire worksheet more readable. For example, you might want to highlight all the items on the worksheet whose values are greater than 500. The following steps illustrate how you might do that:

  1. Select the worksheet cells you want to format and then right-click on the selection:
    Conditional formattingworksheetsfiltering, with paramteters
  2. In the pop-up menu, select Conditional Formats to open the Conditional Formats dialog:
    Conditional formattingworksheetsfiltering, with paramteters
  3. In the Conditional Formats dialog, click the New Conditional ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required