Creating Excel-Like Color Scales in Microsoft Access

In this Microsoft Access tutorial, I'm going to teach you how to set up color scales like you can in Microsoft Excel, where the colors of the values are relative to the maximum and minimum values in the entire column. We will need to use the Max and Min functions, form footer totals, and some other calculations along with Conditional Formatting.

Members

There is no extended cut, but here is the database download:

•  Database Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Conditional Formatting
• Form Footer Totals

Recommended Courses

• Microsoft Excel Beginner Level 2
• Access Expert Courses

Colored Data Bars Series

• Data Bars
• Color Scales
• Colored Data Bars

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

TechHelp Access, Access color scales, Conditional Formatting Access, Max function Access, Min function Access, Access form footer totals, Excel color scales in Access, Access dynamic coloring, Access column comparison, Access calculations in forms