Using Styles in Excel

[Louise]

Hi all

I am trying to create a custom number format so every
time i enter a positive or negative number into a cell,
it changes it to bold automatically. I have looked
through the Custom option under Format Cells but don't
know what "command" to give Excel, to change to bold?

Can anybody offer any urgent help?

Thank you.

Louise

 

[Govind]

Hi,

You should try conditional formatting

Regards

Govind

 

[Louise]

Thank you. I never thought of that!!

Just out of curiosity, is there a command you can use in
a Custom Number Format to change it to bold??

Thanks.

Louise

 

[Govind]

Hi ,

Sorry am not aware of such custom format

Regards

Govind.

 

[Dana DeLouis]

Not sure if this would help. Select your cell, then under Format |
Conditional Formatting...
Select "Formula Is", and use "=ISNUMBER(?)" where ? is the address of your
cell.
Select Bold for your formatting. Now, any numbers in this cell will be
bold.
To apply to a range, say A1:A10, select this range, but for the address,
just use the address of the first cell (A1). Excel will take care of
filling in the correct address for the others.

HTH
Dana DeLouis