Making mulitple IF statements.

T

TimM

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.
 
M

Mangus Pyke

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.
Click to expand...

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-
 
A

Ashish Mathur

Hi,

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

Regards,
 
Top