Excel: Brainbell.com tutorial on controlling conditional formatting with a checkbox


Brainbell.com has a cool tutorial on a unique use of conditional formatting in Excel. How and when to use this method is only limited to your creativity, but I can see it being useful for applying a format only when printing a document.

From the tutorial:

The checkboxes from the Forms toolbar return either a TRUE or FALSE value (checked/not checked) to their linked cell. By combining a checkbox from the Forms toolbar with conditional formatting using the Formula Is option (shown in Figure 2-1), you can turn conditional formatting on and off via a checkbox.

Figure 2-1. The Conditional Formatting dialog with the Formula Is option

figs/exhk_0201.gif

The whole routine is a little involved and pretty nerdy, but the results are super cool.

Have a look for yourself: Brainbell.com: Control Conditional Formatting with Checkboxes

Advertisements
  1. #1 by Asperanzo Dallas on April 16, 2017 - 11:14 pm

    How do the company makes it’s facilities and maintenance plan?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: