I have an excel sheet where in I want the column A to be validated for following conditions.
1.It should accept only dates.
2.In order dd-mmm-yy ex: 5-Jan-12
3.Other than this should make the cell red.
4. The cell may be emoty.
5. But if the cell has values it should support this format only.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…