Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do you...
ok. I have some formulas set in Excel. Is there a way to make it so that
the number would automatically turn red if the outcome of the formula is a negative number? Oh I have Office XP, incase that makes a difference. |
#2
|
|||
|
|||
Look in HELP for FormatConditional Formatting
-- Kind regards, Niek Otten Microsoft MVP - Excel "Na'an" wrote in message ... ok. I have some formulas set in Excel. Is there a way to make it so that the number would automatically turn red if the outcome of the formula is a negative number? Oh I have Office XP, incase that makes a difference. |
#3
|
|||
|
|||
check <format<cells<number<custom and select one which has [RED]
"Na'an" wrote: ok. I have some formulas set in Excel. Is there a way to make it so that the number would automatically turn red if the outcome of the formula is a negative number? Oh I have Office XP, incase that makes a difference. |
#4
|
|||
|
|||
1-Select the cell(s)
2-Go to Format in the toolbar, Format Conditional Formatting... 3-Condition1, choose "Cell Value Is" 4-Next drop choose, "Less than" 5-Place a "0" (zero) in the next box 6-Click the "Format..." button 7-Click the "Font" Tab 8-Click the "Color" drop down 9-Click on the RED square 10-Click the "OK" button DONE! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|