R
Ruth
Hi
I have changed the code in my worksheet to change the background colour when
I enter a certain letter in a cell, is there a way now for me to change the
text colour in that cell to the same as the background so basically you cant
see it. There are 6 different colours that I am using I have seen suggestions
for being able to do this with conditional formatting and formating the cells
but only when numbers are used can I adjust this using letters.
I am currently just using a,b,c,d,e,f as the letters to keep things simple.
Any help would be greatly appreciated.
I have changed the code in my worksheet to change the background colour when
I enter a certain letter in a cell, is there a way now for me to change the
text colour in that cell to the same as the background so basically you cant
see it. There are 6 different colours that I am using I have seen suggestions
for being able to do this with conditional formatting and formating the cells
but only when numbers are used can I adjust this using letters.
I am currently just using a,b,c,d,e,f as the letters to keep things simple.
Any help would be greatly appreciated.