Chapter_16_Conditional_Formatting_Tutorial - Chapter 16...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 16: Excel Tutorial (Using Conditional Formatting) After completing the tutorial, you will be able to use conditional formatting in Excel. This tutorial will use conditional formatting to evaluate a company’s position compared to its competition. D&B and RMA reports give the user information pertaining a specific industry code. The common industry reference is the SIC (Standard Industrial Classification) code. Once you find the four-digit code, you will be able to review the benchmarks for that industry. Conditional Formatting— the following steps can be used to setup a conditional format. The conditional format option within Excel allows you to visually see where a single number stands within the range of acceptable numbers. After this example you will be able to setup a conditional format. The steps below will help you to set it up. 1. Open the workbook labeled “Template.” 2. The D&B industry numbers for SIC 58 (Eating, Drinking Places) for 2005 have already been entered into the spreadsheet. 3.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/10/2012 for the course ACCOUNTING 5450 taught by Professor Brown during the Spring '12 term at Colorado Technical University.

Page1 / 2

Chapter_16_Conditional_Formatting_Tutorial - Chapter 16...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online