Cell Formatting issue i think.

bamaisgreat

Well-known Member
Joined
Jan 23, 2012
Messages
834
Office Version
  1. 365
Platform
  1. Windows
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
 

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.
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.
 
Upvote 0
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):)
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,226,693
Messages
6,192,468
Members
453,726
Latest member
JoeH57

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top