## Use Conditional Formatting to do lookups in related tables

It can be really hard trying to follow a lookup in related tables. I will show you how to use conditional formatting for easy identification.

If you add more rows to the tables, the conditional formatting expands automatically.

**Conditional formatting formula applied to table1:**

**Conditional formatting formula applied to table2:**

**Conditional formatting formula applied to table3:**

You can find the array formula in cell C23 here:

Lookups in three related tables and return multiple values

### Download excel *.xlsx file

How to use a Table name in Data Validation Lists and Conditional Formatting formulas

David Hager gave this valuable comment about how to reference a table name in conditional formatting formulas: =INDIRECT("Table1[Start]") Watch this video to […]

How to use absolute and relative references

What is a reference in Excel? Excel has an A1 reference style meaning columns are named letters A to XFD […]

Drop down list changes cell formatting

You can apply different conditional formatting formulas and formatting to a cell range, using a drop down list. Here is […]

Prevent duplicate records [Data Validation]

Debra Dalgleish demonstrated last week how to block duplicate entries in excel table. I made a comment and I thought I would share […]

Extract unique distinct values from a related table

In a previous post I described how to do lookups in a related table. In this post I am going […]

Working with three related tables

I have written a few posts about two related tables and today I am going to show you how to […]

This post demonstrates how to merge two related tables before creating a pivot table. A pivot table is limited to […]

Lookups in a related table (array formula)

The "new" excel 2010 powerpivot feature and DAX formulas lets you work with multiple tables of data. You can connect […]

### One Response to “Use Conditional Formatting to do lookups in related tables”

### Leave a Reply

### How to comment

**How to add a formula to your comment**

<code>Insert your formula here.</code>

**Convert less than and larger than signs**

Use html character entities instead of less than and larger than signs.

< becomes < and > becomes >

**How to add VBA code to your comment**

[vb 1="vbnet" language=","]

Put your VBA code here.

[/vb]

**How to add a picture to your comment:**

Upload picture to postimage.org or imgur

Use the img tag, like this: <img src="Insert pic link here">

**Contact Oscar**

You can contact me through this contact form

[…] Applying conditional formatting to related tables […]