Using Styles in Excel

  • Thread starter Thread starter Louise
  • Start date Start date
L

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
 
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
 
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
 
Back
Top