Hi all,
I am trying to set up macro which will detect character from list supplied by user in a cell value.
I have 2 sheets: "Data" and "Characters".
In "Characters" user will in write characters which they want to be detected (all in column A, no header). So lets say they want to detect capital O, dash and number 9.
A1 O
A2 -
A3 9
They will paste some report/data dump in sheet called "Data" and then macro will check each cell and highlight it on red if cell value contains any of characters given by user.
I am trying to set up macro which will detect character from list supplied by user in a cell value.
I have 2 sheets: "Data" and "Characters".
In "Characters" user will in write characters which they want to be detected (all in column A, no header). So lets say they want to detect capital O, dash and number 9.
A1 O
A2 -
A3 9
They will paste some report/data dump in sheet called "Data" and then macro will check each cell and highlight it on red if cell value contains any of characters given by user.