I know from several thread that this thing is possible, but there is none of the thread that i search meet my problem exactly.
so here is my problem :
Let's say i have a formula in cell A1 which have a value "The red big apple eaten by a red worm"
could anyone suggest a macro to make the text "red" in that cell become highlighted?
and if it possible i need that macro always automatically work whenever the workbook opened and for everytime I type "red", it will automatically highlighted red without I must manually run the macro.
Thanks you very much for help me
Bookmarks