Cell Formatting issue i think.

[bamaisgreat]

Is there any kind of special formatting or something i can do to say.

Example: when i type in 18mm that actually it could say STOP in the cell.
and as always thanks for all your help. this forum is amazing

 

[Smitty]

Welcome to the Board!

You can't do that without VBA, for which you'd need to give more details.

You could easily set up Conditional Formatting to color the cells depending on certain cell values/limits. You could also use Data Validation to limit the entries, but again, you'll need to give more details. Like the data you'll be entering and why there should be a notification if a certain value is entered.

 

[bamaisgreat]

ok, what I have is a list of steel sizes like 3mm,4mm,5mm,10mm,12mm that will need to be in a decimal size in another cell. I was just wanting to have 2 columns one with the mm sizes and one with the decimal sizes to match, so when they type in Example: 10mm in one cell in the other it will actually show it in a decimal (0.393)

 

[Smitty]

I'd use a Data Validation list instead. That way there's no chance of a screw up in entering values. Here's a link for how to do it.

To get the decimal equivalent you can use a Lookup table.