Download the featured file here https://www.bluepecantraining.com/wp...

In this video tutorial I demonstrate how to use a checkbox to highlight (or change the colour of) a cell or a row.

Table of Contents:

00:00 Introduction
00:28 Add a checkbox to your worksheet
01:25 Specify an output cell for the check box
02:00 Create the other check boxes
03:41 Align and distribute the check boxes
04:14 Write the logical test for conditional formatting
06:31 Apply the conditional formatting
07:23 Apply conditional formatting to an entire row
10:00 Sales target conditional formatting
13:00 Hide the check box outputs
13:18 Example 2 Over budget accounts
15:48 Example 3 Compare 2 lists
18:31 Example 4 Highlight formula cells