- Deleted by Jeet
- Reason: no reason
Hello Mr.HUI,
Please guide me in solving this problem, I have a 5 set of values in A1:A5 as follows:
A1- 78461
A2- 45881
A3- 50613
A4- 97142
A5- 22824
and the input cell is A7 where i will enter the input, in this case its taken as
A7- 5721
Now, i need the formula to find the cell (from A1:A5 ) which have any of 3 digit from A7. if there is a match then the cell should highlighted in Yellow color.
Regards,
jeet
Please guide me in solving this problem, I have a 5 set of values in A1:A5 as follows:
A1- 78461
A2- 45881
A3- 50613
A4- 97142
A5- 22824
and the input cell is A7 where i will enter the input, in this case its taken as
A7- 5721
Now, i need the formula to find the cell (from A1:A5 ) which have any of 3 digit from A7. if there is a match then the cell should highlighted in Yellow color.
Regards,
jeet