formulas using if parameters

[Guest]

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?

 

[Paul B]

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

 

[Guest]

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

 

[Sandy Mann]

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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk