From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Using check boxes and conditional formatting together for dynamic displays

Using check boxes and conditional formatting together for dynamic displays - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Using check boxes and conditional formatting together for dynamic displays

- [Instructor] On this worksheet is an employee list, 2 hundreds of rows, 3 but off to the right is something colorful in column M. 4 If I click a box here that says Full Time, 5 look what happens. 6 This is called a checkbox. 7 I'll check the box for contract and for hourly. 8 And so at different times, 9 rather than filtering the data, 10 which hides the data we don't want to see, 11 we can still see the data, 12 but on the other hand, 13 we're giving special emphasis to one 14 or two or all three of these in different ways 15 by using different colors. 16 And the feature called checkbox 17 we don't see initially in the ribbon menu system. 18 We're also combining this with a better known feature 19 called conditional formatting. 20 It's available on the formulas tab. 21 Now something else is happening too 22 as I click these check boxes, it's off to the right. 23 Ultimately, this doesn't need to be visible, 24 but…

Contents