Hey,
I'm having difficulty trying to figure this out. I want to basically make cases in column (say column K) and make another column (say column O) display color.
So for example, if I write down in Column K the word "Red", I would want the color red to be displayed in column O. If i write "Blue" in column K, I want the color blue to be displayed in column O. Colors would be repeated, so I don't need infinite colors. My range is from 1:100. I've done this via conditional formatting, but I want to do this via VBA.
Any solution or advice, would be appreciated.
Thank you!
I'm having difficulty trying to figure this out. I want to basically make cases in column (say column K) and make another column (say column O) display color.
So for example, if I write down in Column K the word "Red", I would want the color red to be displayed in column O. If i write "Blue" in column K, I want the color blue to be displayed in column O. Colors would be repeated, so I don't need infinite colors. My range is from 1:100. I've done this via conditional formatting, but I want to do this via VBA.
Any solution or advice, would be appreciated.
Thank you!