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