Is it possible to make an IF statement that is something like this. If cell
a1 equals 1 then highlight a certain color, if it is 2 then another color and
so on. I'm trying to do this for work. I want to be able to assign a color
for a type of problem with out having to go to the tool bar and remember what
color it should be, I just want to assign it a number and have it change
automatically. If this is not possible in excel just let me know, for all i
know it's not even possible at all.
--
Thanks
TimM

On Mon, 18 Jul 2005 15:10:02 -0700, "TimM" wrote:
Is it possible to make an IF statement that is something like this. If cell
a1 equals 1 then highlight a certain color, if it is 2 then another color and
so on. I'm trying to do this for work. I want to be able to assign a color
for a type of problem with out having to go to the tool bar and remember what
color it should be, I just want to assign it a number and have it change
automatically. If this is not possible in excel just let me know, for all i
know it's not even possible at all.

Hi Tim,

IF statements are often nested..

IF Format: IF(some criteria, do this if true, do this if false)

This allows use of multiple conditions like this:

IF(some criteria, do this if true, IF(some other criteria, do this if
true, do this if false))

Does that help?

MP-
--
"Learning is a behavior that results from consequences."
B.F. Skinner

Hi,

You may want to try conditional formatting to accomplish this
(ToolsConditional formatting). However there is a restirction to the number
of formats you can use.

Regards,

"TimM" wrote:

Is it possible to make an IF statement that is something like this. If cell
a1 equals 1 then highlight a certain color, if it is 2 then another color and
so on. I'm trying to do this for work. I want to be able to assign a color
for a type of problem with out having to go to the tool bar and remember what
color it should be, I just want to assign it a number and have it change
automatically. If this is not possible in excel just let me know, for all i
know it's not even possible at all.
--
Thanks
TimM