In this Excel video tutorial, Highlight Cells or Rows with a Checkbox in Excel with 2 different practical Examples, Methods. How to Highlight Cells or Rows in Excel with a Checkbox with the cell or in the row. We also gonna see how to highlight entire row in excel using conditional formatting.

Conditional formatting can highlight cells in Excel, can change cells color to red, green, yellow and so on, depending on the chosen criteria.

The first method in Excel to create checkboxes is using the developer tab, where we have a tool called checkbox. We can insert the checkbox on the sheet. Whenever we click on the checkbox, we can mark it or unmark it and we going to have as a result true or false. The true or false, this Boolean condition is what is going to give us the access to use the condition of formatting with the checkboxes. Whenever we have true as result, we can highlight those cells with a green color; whenever we got false as result the, cells remain as it is, without any kind of highlight.

Now, in the second method, we going to use a tool that is in the newer version of excel and it’s also called checkbox. This time it’s much easier and faster to apply the check boxes through out all the rows that we have and we also going to have the boolean conditions, true and false.

00:00 – Subscribe to the channel!
00:22 – Like the video!
00:45 – How to enable the Developer Tab
01:17 – 1st method
04:33 – Conditional Formatting
06:14 – 2st method

#JopaExcel #Dashboard #Excel

Please take the opportunity to connect and share this video with your friends and family if you find it useful.