Dear Members
I am using a data sheet for data entry including a column call time. In call time I enter call time from 0000 to 2359 in different cells of the entire column according to my data need. some time by mistake I enter the call time which is not belong to 0000 to 2359 i.e instead of 0059 I enter 0060 or instead of 2359 I enter 2360 or 2400 which is not a correct time. In this condition I want to apply conditional formatting please help me if someone knows about it
I am using a data sheet for data entry including a column call time. In call time I enter call time from 0000 to 2359 in different cells of the entire column according to my data need. some time by mistake I enter the call time which is not belong to 0000 to 2359 i.e instead of 0059 I enter 0060 or instead of 2359 I enter 2360 or 2400 which is not a correct time. In this condition I want to apply conditional formatting please help me if someone knows about it