In this tutorial, you will learn how to enable conditional data entry in Excel.
You can restrict the data that can be entered into a cell by specific rules. Data is entered only when these rules are met, else it shows an error.
The tutorial shows multiple examples for this:
–Allow data entry from a pre-defined list only (using drop-down lists).
–Allow data entry only when the specified cell(s) are filled.
— Allow DATE entry between two specified dates only.
Read More about it here:
Free Excel Course –
Paid Online Training –
Best Excel Books:
⚙️ Gear I Recommend:
Camera –
Screen Recorder – techsmith.z6rjha.net/26D9Q
USB Mic –
Wireless Mic:
Lighting –
Subscribe to get awesome Excel Tips every week:
Note: Some of these links here are affiliate links!
#Excel #ExcelTips #ExcelTutorial
Watch more new videos about Excel Office | Synthesized by Mindovermetal English
You have a quiet and pleasant way of delivering lessons, thanks.😃👍
Very Interesting couple of minutes. I really enjoy watching your creation.👍🏾👍🏾👍🏾
बहोत बढीया वर्क नया देकर खुशी पाता हे धन्यवाद साहेब
sir i want to use my format which i defined only for cells i.e "a1111a1111"
Hi Puneet, nice video.I have one query how to compare two columns which are not adjacent and sum formula is applied in each cell of both columns.And when one value of cell in one gets equal to another cell of column,both the cells of column or row gets highlighted.Plz reply Puneet I ll wait.plz don't use vba
I have created an excel spreadsheet that employees need to fill in certain cells. I would like to highlight the cells that they are required to the enter information. Like name, date, department etc. How can I do this? I have locked the other cells by following one of your videos. Thank you.
Thanks for all the great videos. Its amazing how much you can do with Excel.
Do you know if there is a way to set columns to be colored based on quartile? I am working w/ a spread sheet that has a column for % To Goal, Conversion Rate, Units and I'd like to have each column auto colored based on the quartile they are in. Example: Quartile 1 = Red, Quartile 2 = Yellow, Quartile 3 = Green, Quartile 4 = Blue.
Is this possible and if so, could you help create a video on it. Thanks so much!
Hello, Very nice videos… Thank you.
I am wondering if you can do the following… Rather than formatting a drop down list, is it possible to copy the format of the source range….Example: Sheet 1 has a drop down list that refers to a range called colors on sheet 2. In sheet two the range colors has 24 colors with each cell formatted with the coorsponding color… now back on sheet one, once a color is picked from the drop down it will automatically import the color from the range…. Thank you.
Could you also explain how to customize the error message that pops up when invalid data is entered?