| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Showing negative values for formula results in red
I have a formula in a cell that is formated as a percentage. I need the
formula results to be in red if the value is a negative number. How do I do that? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Showing negative values for formula results in red
hi
custom format perhaps..... 0.00%;[Red]0.00% regards FSt1 "sherden_hershey" wrote: I have a formula in a cell that is formated as a percentage. I need the formula results to be in red if the value is a negative number. How do I do that? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Showing negative values for formula results in red
You can use conditional formatting Prior to Excel 2007, Format/Conditional
formatting, Excel 2007, Home Tab, Styles, Conditional Formattting, New Rule. Use a formula. If you percentage is in A1, the formula is: =A1<0 then format with a red font color. Tyro "sherden_hershey" wrote in message ... I have a formula in a cell that is formated as a percentage. I need the formula results to be in red if the value is a negative number. How do I do that? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Showing negative values for formula results in red
Assume the cell in question is cell A1
Select A1 Goto the menu FormatConditional Formatting Formula Is: =A1<0 Click the Format button Select the Font tab Select the desired color OK out -- Biff Microsoft Excel MVP "sherden_hershey" wrote in message ... I have a formula in a cell that is formated as a percentage. I need the formula results to be in red if the value is a negative number. How do I do that? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Showing negative values for formula results in red
This works. Thanks!!!
"T. Valko" wrote: Assume the cell in question is cell A1 Select A1 Goto the menu FormatConditional Formatting Formula Is: =A1<0 Click the Format button Select the Font tab Select the desired color OK out -- Biff Microsoft Excel MVP "sherden_hershey" wrote in message ... I have a formula in a cell that is formated as a percentage. I need the formula results to be in red if the value is a negative number. How do I do that? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Showing negative values for formula results in red
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "sherden_hershey" wrote in message ... This works. Thanks!!! "T. Valko" wrote: Assume the cell in question is cell A1 Select A1 Goto the menu FormatConditional Formatting Formula Is: =A1<0 Click the Format button Select the Font tab Select the desired color OK out -- Biff Microsoft Excel MVP "sherden_hershey" wrote in message ... I have a formula in a cell that is formated as a percentage. I need the formula results to be in red if the value is a negative number. How do I do that? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| showing negative values as positive in a bar graph | Excel Discussion (Misc queries) | |||
| Remove Negative Signs from Formula Results | Excel Worksheet Functions | |||
| Showing Cummulative Top5 results with an array-formula...? | Excel Worksheet Functions | |||
| showing multiple results to a formula | Excel Worksheet Functions | |||
| What is the formula to display a negative time results? | Excel Worksheet Functions | |||
Hybrid Mode
