Im going to be honest, Ive spent the last two days trying to figure out how to write a macro for this, I have not written any code and have been studying and watching tutorials but im having some problems. I have also entered some macros i have found for this but the do not work when i try to run them.
I can do it via conditional formatting but its time consuming.
the project is pretty simple, I have a current Wiring diagram macro that populates sheet one cells with connector names, pins, size, wire color, ect that are entered on sheet 2.
I would like to add a macro to when I type “red” the text color changes to red or when I type red/blue the text would be red and blue.
Im just trying to help with the visual aspect of the program.
Any help would be greatly appreciated.