Custom Formatting/Data Validation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a range of cells that use a simple custom format that displays the input as a percentage and if it is negative brackets are placed around it. I wish to prevent this format from being changed (i.e., inputs in this range must be in the form of a percentage). Can I do this using data validation? Thank you in advance for your assistance.
 
No, but you can use Tools-->Protection-->Protect Sheet.
--
_______________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel
http://www.r-cor.com


Aspen said:
I have a range of cells that use a simple custom format that displays the
Click to expand...
input as a percentage and if it is negative brackets are placed around it.
I wish to prevent this format from being changed (i.e., inputs in this range
must be in the form of a percentage). Can I do this using data validation?
Thank you in advance for your assistance.
 
Hi!

You say data input "must be in the form of a percentage".

Do you mean that the operator will actually enter things like 23% o
-5.7%?
Or will s/he enter 23 or -5.7 and the cell will show 23% etc?

If it's the latter, is there a fixed range for values (max & min)?

If there is, you could use data validation to catch invalid entrie
provided your cell format adds the % sign (like the standard percentag
format does).

Al
 
Back
Top