| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
can the negative numbers in an IF statement be in a diff color th.
can the numbers in an IF statement be automatically programmed to change
colors when number is negative(red for negative and blue for positive) |
|
#2
|
|||
|
|||
|
Use custom format in the cell with the if statement and a format like
0.00;[Red]0.00 or use formatconditional formatting Regards, Peo Sjoblom " wrote: can the numbers in an IF statement be automatically programmed to change colors when number is negative(red for negative and blue for positive) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating growth with negative numbers | Excel Worksheet Functions | |||
| Converting negative numbers in a range of cells to zero | Excel Discussion (Misc queries) | |||
| can the negative numbers in an IF statement be in a diff color th. | Excel Worksheet Functions | |||
| Subtracting Negative Numbers | Excel Worksheet Functions | |||
| Negative Numbers | Excel Discussion (Misc queries) | |||
Hybrid Mode
