total column with a bold number for negatives

[Guest]

I have 2 columns a and b I take the answer from a1 and substract it from a2
then the answer goes in b2. what i want is the answer in b2 to be bold if its
a negative number. what do i need to do.

 

[Guest]

Try Conditional Formatting:

Select the cells to be impacted

From the Excel main menu:
<format><coditional formatting>
Condition 1:
Cell value is: less than 0
Click the [Format...] button
Set the font to: Red, Bold
Click the [OK] buttons

Is that something you can work with?

***********
Regards,
Ron

XL2002, WinXP