Cell formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Format=>Custom:

"(" @ ")"

The brackets will only appear when the data is entered.

HTH
 
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
 
Not as far as I know.

Candace said:
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.
Click to expand...
 
Back
Top