I have a string of numbers in a cell and I need a macro to search for the number 530BA and turn it red.
numbers look like the following: 422EDA 651GCB, 525TAA, 530ZBA, 411ZXP, 662MGA, 422EDA, 530ZBA, 411ZXF, 420LDA, 525KEA.
There could be 20+ number in a cell.
Is there simple macro I can run to do the trick?
numbers look like the following: 422EDA 651GCB, 525TAA, 530ZBA, 411ZXP, 662MGA, 422EDA, 530ZBA, 411ZXF, 420LDA, 525KEA.
There could be 20+ number in a cell.
Is there simple macro I can run to do the trick?