Question: In the worksheet 4000 dates, in cells A2:A4000, apply data validation so that if and only if the date in that cell is earlier than

In the worksheet 4000 dates, in cells A2:A4000, apply data validation so that if and only if the date in that cell is earlier than the date in the one cell immediately above it, the command Circle Invalid Data will encircle such values. For example, if the date in A997 is earlier than the date in A996, it should be considered erroneous. Your data validation implementation should include an appropriate error message

Please explain steps of how to solve this on excel

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!