kimberly090
Board Regular
- Joined
- May 22, 2014
- Messages
- 99
I have my excel worksheet.
I wish to highlight the duplicate number which will ignore the formula that I am referring to the last cell.
For example:
I wish to ignore the highlighting in A2 and A3 as they are formula but not value.
I wish to highlight the duplicate number which will ignore the formula that I am referring to the last cell.
For example:
![O11Qy.png](/board/proxy.php?image=http%3A%2F%2Fi.stack.imgur.com%2FO11Qy.png&hash=20d63989192e5b28d73a284065dc2077)
I wish to ignore the highlighting in A2 and A3 as they are formula but not value.