Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ADD COLOR TO FORMULAS
I am new to using IF Formulas and i have two questions.
First: I have an existing simple subtraction formula in a cell, can i add a IF Formula onto it. for example : In cell L13 "=M13-K13" CAN i now ADD a IF formula on top of this simple formula??? Second Question: CAN i add color to a formula, specifically an IF formula???? Example "=IF(L13<M13) Then COLOR IS RED, IF NOT COLOR IS BLACK" I know this is not really how IF formulas work, i am just explaining what i need to do. So to sum up, i need to add an IF formula on top of a subtraction formula, AND use a COLOR FORMAT in the IF FORMULA. Please help any way possible. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
ADD COLOR TO FORMULAS
-- Kevin Backmann "Grizzbear" wrote: I am new to using IF Formulas and i have two questions. First: I have an existing simple subtraction formula in a cell, can i add a IF Formula onto it. for example : In cell L13 "=M13-K13" CAN i now ADD a IF formula on top of this simple formula??? Second Question: CAN i add color to a formula, specifically an IF formula???? Example "=IF(L13<M13) Then COLOR IS RED, IF NOT COLOR IS BLACK" I know this is not really how IF formulas work, i am just explaining what i need to do. So to sum up, i need to add an IF formula on top of a subtraction formula, AND use a COLOR FORMAT in the IF FORMULA. Please help any way possible. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
ADD COLOR TO FORMULAS
Depending on the version of excel and the number of conditions, you may be able
to use Format|Condiditional formatting to show the colors that you like. Grizzbear wrote: I am new to using IF Formulas and i have two questions. First: I have an existing simple subtraction formula in a cell, can i add a IF Formula onto it. for example : In cell L13 "=M13-K13" CAN i now ADD a IF formula on top of this simple formula??? Second Question: CAN i add color to a formula, specifically an IF formula???? Example "=IF(L13<M13) Then COLOR IS RED, IF NOT COLOR IS BLACK" I know this is not really how IF formulas work, i am just explaining what i need to do. So to sum up, i need to add an IF formula on top of a subtraction formula, AND use a COLOR FORMAT in the IF FORMULA. Please help any way possible. Thanks -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
ADD COLOR TO FORMULAS
"Grizzbear" wrote in message
... I am new to using IF Formulas and i have two questions. First: I have an existing simple subtraction formula in a cell, can i add a IF Formula onto it. for example : In cell L13 "=M13-K13" CAN i now ADD a IF formula on top of this simple formula??? Second Question: CAN i add color to a formula, specifically an IF formula???? Example "=IF(L13<M13) Then COLOR IS RED, IF NOT COLOR IS BLACK" I know this is not really how IF formulas work, i am just explaining what i need to do. So to sum up, i need to add an IF formula on top of a subtraction formula, AND use a COLOR FORMAT in the IF FORMULA. Please help any way possible. Thanks You need a separate formula for colouring which you place in Conditional Formatting (on the Format Menu). Change the first entry in CF pop-up from "Cell Value Is" to "Formula Is" and enter your condition(s) and required format(s). |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
ADD COLOR TO FORMULAS
Conditional Formatting worked!!!! thanks guys, i achieved exactly what i was
looking for. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill in Color within formulas | Excel Worksheet Functions | |||
how can i have certain formulas come up in a specific color | New Users to Excel | |||
Color in Excel Formulas | Excel Discussion (Misc queries) | |||
Color in Excel Formulas | Excel Discussion (Misc queries) | |||
Color Cell Formulas | Excel Discussion (Misc queries) |