Let's say I have Column Arow 1 to 5 is where I put in the values needed for a certain calculation

A1: 01/01/1991

A2: 01/01/1992

A3: 01/01/1993

A4: 01/011994

A5: 01/01/1995

As you can see A1 to A5 are supposed to be dates, but I mistyped the value in A4

is there anyway for Excel to notify me if I mistyped a date value?

can I make Excel hilight A4 in red if I made this error?

or any other kind of suggestions?

please help

thank you for reading

A1: 01/01/1991

A2: 01/01/1992

A3: 01/01/1993

A4: 01/011994

A5: 01/01/1995

As you can see A1 to A5 are supposed to be dates, but I mistyped the value in A4

is there anyway for Excel to notify me if I mistyped a date value?

can I make Excel hilight A4 in red if I made this error?

or any other kind of suggestions?

please help

thank you for reading

Last edited: