Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas using if parameters
I need to change the color of the font in a cell that equals my true value
and my false value needs to stay the same. ie, if overbudget, i need the cell color to be red, if at or underbudget, i need the cell color to stay black. Is this at all possible? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas using if parameters
Dana, have a look at format conditional formatting
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Dana" <Dana @discussions.microsoft.com wrote in message ... I need to change the color of the font in a cell that equals my true value and my false value needs to stay the same. ie, if overbudget, i need the cell color to be red, if at or underbudget, i need the cell color to stay black. Is this at all possible? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas using if parameters
You can use conditional formatting.
Assume budget = $1000. Then you can set conditional formatting for <=$1000 = black, otherwise red. Steps: 1)Select the cell(s) you want to conditionally format. 2) Go to Format--Conditional Format 3) Condition 1: Cell value is less than or equal to $1000 (this can also be a reference, e.g., A1, where A1 has $1000). Click the format button and select black. 4) Click Add to add a second condition. 5) Condition 2: Cell value is greater than $1000. Click the format button and select red from the color palette. 6) Click OK and test it out. Dave -- Brevity is the soul of wit. "Dana" wrote: I need to change the color of the font in a cell that equals my true value and my false value needs to stay the same. ie, if overbudget, i need the cell color to be red, if at or underbudget, i need the cell color to stay black. Is this at all possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy only cells with formulas in another row? | Excel Worksheet Functions | |||
How to change column letters to correct ones in many formulas automatically? | Links and Linking in Excel | |||
How to change column letters to correct ones in many formulas automatically? | Excel Worksheet Functions | |||
how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |