This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I need a text to display when a cell shows to be greater than a certain value.
The cell is going to be a locked cell though.
I tried Data Validation, and it will not display it when it is a locked cell.
It will as long as it is not a locked cell.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Set R73, R74 R75 and R77 data validation.
You can also custom error alert.
Which cells you want to set data validation alert?
You may upload file in private message.
Could you share a test file? Then I can have a try on it. If the locked cell is a formula, you can set data validation on reference cells.
For sharing file, you may upload it to OneDrive or any other cloud drive and then post the link here.
Can the worksheet be emailed to you?
There are strict rules to follow where I work.
Could you share a test file? Then I can have a try on it. If the locked cell is a formula, you can set data validation on reference cells.
For sharing file, you may upload it to OneDrive or any other cloud drive and then post the link here.