I would like the Macro to find the table in the designated sheet , start the text search and search all the cells in the table for cells that contain the text entered by the user.
for each cell that contains the specific text it would paint it in the color that the user entered.
please see the example and detailed instructions in the attached file.
thank's
Amit
for each cell that contains the specific text it would paint it in the color that the user entered.
please see the example and detailed instructions in the attached file.
thank's
Amit