Scribd
Upload
10 views6 pages

Cell Validation Criteria Guide

data validation in excel

Uploaded by

Sri Raman V
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
10 views6 pages

Cell Validation Criteria Guide

data validation in excel

Uploaded by

Sri Raman V
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Create Validation for the below cells with the given Criteria

Strictly 12 Digits Can be within 10 and 16 Maximum of 20 characters


Social Password Social User name
Create Validation for the below cells with the given Criteria
After 20th od December Before the 15th of Jan
Tour Start Date Tour End Date
Create Validation for the below cells with the given Criteria
After 11 AM After 11 AM and Before the 10 PM
Order Time Order Time
Create Validation for the below cells with the given Criteria
Pizza, Burger and Fries Only Use the Reference in the H column
Order Time Order Time
Field
Product ID
Create Validation for the below cells with the given Criteria on the right Product Category
Product Cost
Product ID Product Category Product Cost Product Margin % Product Sell Date Product Margin %
Product Sell Date
Criteria
Should be 6 exactly Characters
Should be any of these 3, "Pizza", "Burger", "Fries"
Should be between 100 and 240
Least Profit Margin should be 35%
Should have been sold within the year 2025

You might also like