I am wanting to verity the data entered.
I have a conditional format to check the data and highlight in red if it does not equal
What I would like to have is the first input listed as a comment in the cell.
Example:
In A1 10 (In Verify sheet) In AA1 11 (the original value in the Verify sheet copied from the Original data Entry sheet)
The Conditional formula highlight it in red indicating they don't match.
What I would like to see in the comments is the Original value as a comment in A1, so I can determine which is correct.
I need this for Columns A corresponding to AA, B corresponding to AB, C corresponding to AC.
I have a conditional format to check the data and highlight in red if it does not equal
What I would like to have is the first input listed as a comment in the cell.
Example:
In A1 10 (In Verify sheet) In AA1 11 (the original value in the Verify sheet copied from the Original data Entry sheet)
The Conditional formula highlight it in red indicating they don't match.
What I would like to see in the comments is the Original value as a comment in A1, so I can determine which is correct.
I need this for Columns A corresponding to AA, B corresponding to AB, C corresponding to AC.