Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I MAKE A BIG X APPEAR IN A CELL THAT IS NOT IN USE?
I WANT A BIG X OR SLASH/ TO APPEAR IN PLACE FOR WHEN I'M NOT USING A CELL FOR
DATA...HOW TO DO THIS??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I MAKE A BIG X APPEAR IN A CELL THAT IS NOT IN USE?
I find that shouting very loud always helps. Typing in all CAPS is
considered to be shouting and not proper netiquette here. Perhaps a bit more information might also help. -- Don Guillett Excel MVP SalesAid Software "FABIC" wrote in message ... I WANT A BIG X OR SLASH/ TO APPEAR IN PLACE FOR WHEN I'M NOT USING A CELL FOR DATA...HOW TO DO THIS??? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
HOW DO I MAKE A BIG X APPEAR IN A CELL THAT IS NOT IN USE?
On Jul 4, 11:16 am, FABIC wrote:
I WANT A BIG X OR SLASH/ TO APPEAR IN PLACE FOR WHEN I'M NOT USING A CELL FOR DATA...HOW TO DO THIS??? Type an X or whatever you want in an unused cell. Use Fomat/Font to make it as big as you want. Copy it to the other unused cells. When you enter data in the cell the big X will be replaced with the data. More appropriate would be to use Conditional Formatting. Type the following formula in the Conditional formula space in cell B2 =B2="" and then choose bright red, or light blue or solid black for a pattern. Using the format brush, copy B2 to all the cells you want so indicated. The advantage to Conditional Formatting is that when you erase the data the pattern format will return. ed |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make a blank cell in a formula cell with a range of cell | Excel Discussion (Misc queries) | |||
format cell to show leading zeros and make cell a three digit fiel | Excel Worksheet Functions | |||
How do I make my arrow buttons move from cell to cell in Excel? | Excel Discussion (Misc queries) | |||
how do I make a word typed in a cell go to a specific cell in anot | Excel Discussion (Misc queries) | |||
Can you make a cell with a diagonal, so that you can edit the upper and lower part of the cell? | New Users to Excel |