View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ruth Ruth is offline
external usenet poster
 
Posts: 132
Default text and background colour

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.
--
Thanks

Ruth