route217
asked on
Conditional Format - Prevent User entering USA Date formats into Excel 2010
hi Experts Using excel 2010
I am currently using the following to format dates in excel [<1]"";dd/mm/yy - which works fine. I want to prevent users from entering dates in any other format other then UK...so USA formats allowed if entered colour cell red.
not sure how to do this...
I am currently using the following to format dates in excel [<1]"";dd/mm/yy - which works fine. I want to prevent users from entering dates in any other format other then UK...so USA formats allowed if entered colour cell red.
not sure how to do this...
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER