Highlight Cells or Rows with a Checkbox in Excel | 2 Methods
HTML-код
- Опубликовано: 24 июл 2024
- 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
Excellent, thank you
My True Column already turn green. But how about the false if i want it highlighted red row. Teach me sensei
Nice!! what excel year is this? mine doesn't have the second option!
How to get the method 2?
I dont see any checkbox in insert menu in my excel 😢
same as me
@@firdausfaizal1229 me too
idk man im confused i would stick to google docs if my company didn't block it oh well