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 |
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) |