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 )

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 )

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 )

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 )