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: