Loading
Store.Tips.Net Tips.Net Store

Excel 2010 Conditional Formatting (Table of Contents)

Summary: Conditional formatting allows you to modify how information is displayed based upon criteria that you define. Excel 2010 Conditional Formatting is the definitive resource for understanding how to take advantage of this powerful feature of Excel; this is the complete table of contents for that resource.

Excel 2010 Conditional Formatting (Table of Contents)

Excel 2010 Conditional Formatting, Second Edition, includes all the information you need to make sense of working with Excel's conditional formatting feature. The following is the Table of Contents:

Introduction

  • A Word about Versions
  • Need More Tips?
  • Sharing this E-Book

Conditional Formatting Basics

  • Defining a Single Condition
  • Working with Multiple Conditions
  • More than Three Conditional Formats
  • Defining a Rule Based on Cell Values
  • Defining a Rule Based on Cell Contents
  • Defining a Rule Based on Cell Ranking
  • Defining a Rule Based on a Cell's Relation to Average
  • Defining a Rule Based on Duplicate Status
  • Defining a Rule Based on a Formula
  • Copying Conditional Formatting
  • Deleting Conditional Formats
  • Finding Cells Containing Conditional Formats
  • Losing Formatting
  • Protecting Conditional Formatting
  • Detecting Errors in Conditional Formatting Formulas
  • Diagonal Borders in a Conditional Format

Conditionally Formatting Cells

  • Coloring Cells with Formulas
  • Shading a Cell until Something is Entered
  • Highlighting Values in a Cell
  • Highlighting Cells Containing Specific Text
  • Conditionally Highlighting Cells Containing Formulas
  • Shading Based on Odds and Evens
  • Displaying Negative Percentages in Red
  • Hiding Individual Cells
  • Checking for Messages in Cells

Conditionally Formatting Rows

  • Conditionally Formatting an Entire Row
  • Shading Rows with Conditional Formatting
  • Checking for Duplicate Rows Based on a Range of Columns
  • Automatic Lines for Dividing Lists
  • Changing Shading when a Column Value Changes
  • Formatting Subtotal Rows

Real-World Conditional Formatting

  • Alerts for Approaching Due Dates
  • Pulling All Fridays
  • Conditional Formatting Based on Date Proximity
  • Conditionally Formatting for Multiple Date Comparisons
  • Noting Inactivity within a Timeframe
  • Formatting Phone Numbers outside a Desired Range
  • Conditionally Formatting Non-Integers
  • Determining a Name for a Week Number
  • Changing Excel's Background Color

Advanced Considerations

  • Conditional Format that Checks for Data Type
  • Conditional Formats that Distinguish Blanks and Zeroes
  • Counting Colors from Conditional Formats
  • Changing Font Face and Size Conditionally
  • Sorting or Filtering by Conditional Format Results
  • Moving Cell Borders when Sorting
  • Leaving a Cell Value Unchanged If a Condition Is False
  • Removing Conditional Formats, but Not the Effects
  • Checking for Proper Entry of Array Formulas
  • Conditional Formatting with Data Imported from Access
  • Checking Lock Status of Cells
  • Checking All Cell Formatting in VBA
  • Conditionally Playing an Audio File

Description CD Download
Excel 2013 Conditional Formatting Buy on CD
ISBN 978-1-61359-174-1 (107 pages)
$24.99
Buy Download
ISBN 978-1-61359-173-4 (1.6 MB)
$19.99
Excel 2010 Conditional Formatting Buy on CD
ISBN 978-1-61359-172-7 (103 pages)
$24.99
Buy Download
ISBN 978-1-61359-171-0 (2.8 MB)
$19.99
Excel 2007 Conditional Formatting Buy on CD
ISBN 978-1-61359-170-3 (103 pages)
$24.99
Buy Download
ISBN 978-1-61359-169-7 (2.6 MB)
$19.99
Excel 2003 Conditional Formatting Buy on CD
ISBN 978-1-61359-168-0 (77 pages)
$24.99
Buy Download
ISBN 978-1-61359-167-3 (1.7 MB)
$19.99
Excel Conditional Formatting Four-Pack
 
Great deal! All four versions
for the price of two-and-a-half (you get one-and-a-half free).
Buy on CD
ISBN 978-1-61359-176-5 (390 pages)
$62.47
Buy Download
ISBN 978-1-61359-175-8 (8.3 MB)
$49.97

You can also order Excel 2010 Conditional Formatting by calling our order line: 801-607-2035.

 
 

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us

 

Advertise with Us

Our Privacy Policy

Our Sites

Tips.Net

Beauty and Style

Cars

Cleaning

Cooking

DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2013)

Gardening

Health

Home Improvement

Money and Finances

Organizing

Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2013)

Our Products

Premium Newsletters

Helpful E-books

Newsletter Archives

 

Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2014 Sharon Parq Associates, Inc.