- Trending Categories
- Data Structure
- Operating System
- MS Excel
- C Programming
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to highlight unlocked cells in Excel?
In the article, the users are going to highlight unlocked cells which are not locked in Microsoft Excel. There are the several features in the excel sheet including conditional formatting, format cells that the users have to fill any type of color according to the need. The users can use the formula for changing cell value in the new formatting rule dialog box. The users can use select the range in which you want to fill the color in any cell.
Deliberate the excel sheet with the data. First, open the excel sheet and create the data one by one. In this sheet, type any type the data like alphabets, numbers and the dates which the users need to highlight only unlocked cells in the given list as shown below.
In the excel sheet, the created data is displayed. Place the cursor in the cell A1 and select all the cells which the users inserted the random numbers one by one.
After selecting all the data in the sheet, right-click on the data and click on the Format Cells option that opens a dialog box. There are two tabs Locked and Hidden, enable the Locked option that will lock all the cells. If the users want to highlight unlocked cells, so it needs to unlock the cells that the users want to highlight. Select some cells and right-click on it. Click on the Format Cells that opens the dialog box. Disable the Locked tab that will unlock the cells like this.
After selecting all the cells, Place the cursor in the ribbon. In the ribbon, there are many tabs included in the top corner. Place the cursor in the Home tab and click on the tab that has many options included. On Home tab, place the cursor and click on the drop-down menu of Conditional Formatting. On this tab, click on the New Rule tab that opens the dialog box as shown below.
In the dialog box, there are the rules included one by one. Select and click on the rule Use a formula to determine which cells to format that enables the drop-box.
In the dialog box, there is the input type and place the cursor on it. Now, enter the formula =CELL(“protect”,A1)=0 to highlight the unlocked cells. In the dialog box, place the cursor and click on the Format button that opens a new dialog box Format Cells that has the Fill tab. In the dialog box of Format Cells, there are the tabs included. Now, click on the Fill tab that displays the color theme like this.
In the dialog box, choose any color in the color theme as shown which the users want to highlight unlocked cells then click on the ok button that closes the dialog box of Format Cells. After closing the Format Cells dialog box, the New Formatting Rule dialog box will display as shown below.
In the dialog box, click on the ok button that will close the New Formatting dialog box. After closing the dialog boxes, it will highlight unlocked cells with the selected color from color theme randomly as shown below.
The users utilized an easy instance to display how can highlight the unlocked cells whole with different color randomly. The users used the necessary tabs which are included in the ribbon. The users have to practice the essential options from ribbon and modify the data according to the need.
Kickstart Your Career
Get certified by completing the courseGet Started