Forum Discussion
Slight problem with data validation in Excel 365 In insider
Thank you for responding.
Q and S are both manually entered currency amounts that can be zero (Empty), contain a number or not. They are equal most of the time but do not have to be. All I want to do is flag a "Possible" data entry error when there is a value entered in "S" that does not match the value in "Q".
I am aware of the Copy/Paste issue, thank you.
TheOldPuterMan AKA John
In that case, select S3 and apply the Custom Data Validation using the formula give below...
=S3=Q3That will give an error if the value entered in S3 is not equal to the value in Q3.
And if you enter the value in S3 first and then in Q3 and want to make sure that the value entered in Q3 must be equal to the value exists in S3, apply a Custom Data Validation in Q3 using the formula...
=Q3=S3
If that takes care of your original question, please accept this post as an Accepted/Best response which will mark your question as Solved.