Hi there;
I'd like to change the background colour of three columns' cells, based on text that is entered into them -- e, r, o, a, or p. I would also like to change the font color to the same color index value, so that the text becomes hidden.
I have tried modifying many similar macros, but am having trouble getting them to suit my exact purposes.
Has anyone created anything like this?
I'd like to change the background colour of three columns' cells, based on text that is entered into them -- e, r, o, a, or p. I would also like to change the font color to the same color index value, so that the text becomes hidden.
I have tried modifying many similar macros, but am having trouble getting them to suit my exact purposes.
Has anyone created anything like this?