Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
total column with a bold number for negatives
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
total column with a bold number for negatives
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 "Tommy" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Non updatable Unique Random Number | Excel Worksheet Functions | |||
Changing a Number in a Column Using Arrays | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Add total number of rows (text) in a column | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) |