Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Understanding Anova in Excel
  • How To Create Frequency Distribution in Excel
  • How to do a t-Test in Excel?
  • How to Create Area Chart in Excel
  • How to calculate average last N values in a table in Excel

References

  • How to get first column number in range in Excel
  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions
  • Perform case-sensitive Lookup in Excel
  • Offset in Excel
  • MATCH function: Description, Usage, Syntax, Examples and Explanation

Data Validations

  • Excel Data validation with conditional list
  • Excel Data validation date in next 30 days
  • Excel Data validation must not contain
  • Excel Data validation unique values only
  • Excel Data validation date in specific year

Highlight unprotected cells in Excel

by

This tutorial shows how to Highlight unprotected cells in Excel using the example below;

Formula

=CELL("PROTECT",A1)=0

Explanation

To highlight unprotected cells (cells that are unlocked) with conditional formatting, you can use a formula based on the CELL function. In the example shown, the custom formula used to set up conditional formatting is:

=CELL("PROTECT",A1)=0

Where A1 represents the active cell in the selection when the rule was defined.

How this formula works

The CELL function can provide a wide range of information about cell properties. One property is called “protect” and indicates whether a cell is unlocked or locked. All cells start out “locked” in a new Excel workbook, but this setting has no effect until a worksheet is protected.

The CELL function returns either 1 or zero to indicate “on” or “off”. In this case we are comparing the result to zero, so when CELL returns 0, the expression returns TRUE and the conditional formatting is triggered. When CELL returns 1, the expression returns FALSE and no conditional formatting is applied.

Post navigation

Previous Post:

COSH function: Description, Usage, Syntax, Examples and Explanation

Next Post:

Excel Data validation require unique number

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • IF with boolean logic in Excel
  • How to return blank in place of #DIV/0! error in Excel
  • IF, AND, OR and NOT Functions Examples in Excel
  • OR function Examples in Excel
  • How to use Excel AND Function

Date Time

  • Assign points based on late time in Excel
  • How to show last updated date stamp in Excel
  • How to Calculate Age in Excel
  • Add business days to date in Excel
  • WORKDAY.INTL function: Description, Usage, Syntax, Examples and Explanation

Grouping

  • Group numbers at uneven intervals in Excel
  • How to randomly assign people to groups in Excel
  • Running count group by n size in Excel
  • Group arbitrary text values in Excel
  • Categorize text with keywords in Excel

General

  • How to get original price from percentage discount in Excel
  • Currency vs Accounting Format in Excel
  • List worksheet index numbers in Excel
  • How to get random value from list or table in Excel
  • How to calculate percent of goal in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning