Step by step process of making the column values inside a time line of a day. NOTE: to use this skill User needs to login into Microsoft Applications.
-
1.
Open Microsoft Excel on the Web
-
2.
Click on Search Bar, Which enables the User to find the files in Outlook Excel. Type the file name, which will show recently Opened files. Once done, click on the "Next" button on the Supervity instruction widget. Open the File under the Search bar.
-
3.
Go to the Sheet Where you want to apply the Data Validation with Date Range. Once done, click on the "Next" button on the Supervity instruction widget.
-
4.
Click on the Column Address where you want to apply Data Validation. Once done, click on the "Next" button on the Supervity instruction widget.
-
5.
Click on the Data Button.
-
6.
Click on Data Validation Button.
-
7.
Click on Any value Dropdown.
-
8.
Select the Time Option.
-
9.
Click on the Dropdown and Select the condition for the Time. Once done, click on the "Next" button on the Supervity instruction widget.
-
10.
Enter the Details according to the condition selected. in the below-mentioned format, HH:MM (24 Hr Format) Once done, click on the "Next" button on the Supervity instruction widget.
-
11.
Click on Input Message.
-
12.
Click on Title and Enter the title to display for the user. Once done, click on the "Next" button on the Supervity instruction widget.
-
13.
Click on the Message, Enter the message you want to a display for the User. Once done, click on the "Next" button on the Supervity instruction widget.
-
14.
Click on Error Alert, This is used to say the Alert Message User for Entering wrong details.
-
15.
Click on the Alert Title, and Enter the Alert title. Once done, click on the "Next" button on the Supervity instruction widget.
-
16.
Click on the Alert Message, type the Alert Message for the User. Once done, click on the "Next" button on the Supervity instruction widget.
-
17.
Click on Apply, to Apply the Settings for the above Mentioned Details.
