Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
text and background colour
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 On Oct 21, 5:08*pm, Ruth wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
text and background colour
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 "Pete_UK" wrote: 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 On Oct 21, 5:08 pm, Ruth wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sheet Background Colour | Excel Discussion (Misc queries) | |||
In Excel, colour formatting (text and background) reverts to blk | Excel Discussion (Misc queries) | |||
change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
excel and background colour | Setting up and Configuration of Excel | |||
excel and no background colour | Excel Discussion (Misc queries) |