![]() ![]() Or =IF(Sheet3!$E1=TRUE,TRUE,FALSE) if the check boxes linked to another worksheet.Ģ.3 Click the Format button to specify a highlighted color for the rows In the New Formatting Rule dialog box, you need to:Ģ.1 Select the Use a formula to determine which cells to format option in the Select a Rule Type box Ģ.2 Enter formula =IF($J1=TRUE,TRUE,FALSE) into the Format values where this formula is true box ![]() Select the rows you need to highlight with checkboxes, then click Conditional Formatting > New Rule under the Home tab. Now you need to create a Conditional Formatting rule as follows step by step.ġ. Note: All linked cells should be consecutive and locating in the same column. Repeat step 1 until all check boxes are linked to the adjacent cells or cells in another worksheet. Tip: If you don't want to have values associated in adjacent cells to checkboxes, you can link the checkbox to another worksheet's cell such as =Sheet3!$E1.Ģ. ![]() Please select the first check box in I1, enter formula =$J1 into the formula bar, and then press the Enter key. Now check boxes have been inserted to cells in column I. You need to insert checkboxes into cells one by one manually by clicking Developer > Insert > Check Box (Form Control).Ģ. You can create a Conditional Formatting rule to highlight cell or row with checkbox in Excel. Highlight cell or row with checkbox with VBA code Highlight cell or row with checkbox with Conditional Formatting But how to achieve it in Excel? This article will show you two methods to achieve it. When a checkbox is checked, a specified row or a cell will be highlighted automatically. How to highlight cell or row with checkbox in Excel?Īs below screenshot shown, you need to highlight row or cell with checkbox. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |