Basic custom data validation formula

labeattie

New Member
Joined
May 8, 2014
Messages
2
Hi all,

How would I go about making sure that any data entry in a column (say column A), is less than or equal to the value of a specific cell (say c1). I thought this was pretty easy and I think I've done it before, but I can't seem to get it to work now.

Thanks in advance,
labeattie
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

mcmahobt

Board Regular
Joined
Sep 2, 2014
Messages
55
By validation, do you mean return something along the lines of "False" or "No" if it is greater than the value in C1? Or maybe a colored cell? What do you mean by "make sure" any data is less <= the value in C1?
 

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
23,920
Select A1, enter the validation formula =(a1<=$C$1)

Copy the cell, pasteSpecial>Validation it to the rest of column A
 

Watch MrExcel Video

Forum statistics

Threads
1,123,510
Messages
5,602,075
Members
414,500
Latest member
kevdragon1

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
Top