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?

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?

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?

formulas using if parameters
 

Dave,

What you posted will work but you actually do not need a condition to set
Black if black is the default font colour so just setting Conditional Format
for a red font for 1,000 or over will suffice.

You could also set a Custom Number format (ie Format Cells Number
Custom) of:

[Red][=1000]General;General

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"Dave F" wrote in message
...
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?