text and background colour

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

 

[Pete_UK]

Unless you are using XL2007, you are limited to 3 conditional formats
per cell. There are ways around this limit by using a macro (or Bob
Phillips' CFPlus add-in).

Hope this helps.

Pete

 

[Ruth]

Hi Pete

I found a few examples of where people have been able to use up to 6
conditional formats by going into format cells - number - custom and then
entering in a custom formula that went something like [Red]>100;0[Green]
(this is from memory so it isnt exactly correct). After entering this you can
go into conditional format and change that as normal so in all it could have
up to 6.
I have tried to ammend the above to say a letter rather than > 100 etc but I
cant get it to work. It might not be possible but wanted to ask the question.


--
Thanks

Ruth

Unless you are using XL2007, you are limited to 3 conditional formats
per cell. There are ways around this limit by using a macro (or Bob
Phillips' CFPlus add-in).

Hope this helps.

Pete