Download the featured file here https://www.bluepecantraining.com/wp-content/uploads/2022/12/Conditional-Formatting-with-Checkbox.xlsx

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

------------------------------------
------------------------