Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell formatting
Is it possible to format a cell such that it has a opening and closing
parenthesis? The cell is not for a number. Rather, if need be, my user will enter an "X" in the cell. So when the user opens the Excel spreadsheet, the cell should look like ( ) But if the user places an "x" in the field, then the cell should look like ( x ) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell formatting
try:
Format=Custom: "(" @ ")" The brackets will only appear when the data is entered. HTH "Candace" wrote: Is it possible to format a cell such that it has a opening and closing parenthesis? The cell is not for a number. Rather, if need be, my user will enter an "X" in the cell. So when the user opens the Excel spreadsheet, the cell should look like ( ) But if the user places an "x" in the field, then the cell should look like ( x ) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell formatting
Hi,
You could use Toppers format and Conditional and conditional formatting to turn the cell (Say) red if it was blank Format|conditional formatting|formula is =isblank(A1) and select a colour Mike "Candace" wrote: Thanks, Toppers. But is there any way to make it so that the parenthesis will show whether data is entered or not. My users need this visual que to remind them to look at the field/cell. "Toppers" wrote: try: Format=Custom: "(" @ ")" The brackets will only appear when the data is entered. HTH "Candace" wrote: Is it possible to format a cell such that it has a opening and closing parenthesis? The cell is not for a number. Rather, if need be, my user will enter an "X" in the cell. So when the user opens the Excel spreadsheet, the cell should look like ( ) But if the user places an "x" in the field, then the cell should look like ( x ) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell formatting
Not as far as I know.
"Candace" wrote: Thanks, Toppers. But is there any way to make it so that the parenthesis will show whether data is entered or not. My users need this visual que to remind them to look at the field/cell. "Toppers" wrote: try: Format=Custom: "(" @ ")" The brackets will only appear when the data is entered. HTH "Candace" wrote: Is it possible to format a cell such that it has a opening and closing parenthesis? The cell is not for a number. Rather, if need be, my user will enter an "X" in the cell. So when the user opens the Excel spreadsheet, the cell should look like ( ) But if the user places an "x" in the field, then the cell should look like ( x ) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting question (if cell = 0, wrap cell in quotes) | New Users to Excel | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions | |||
Conditional cell background formatting, based on cell content | Excel Discussion (Misc queries) |