hi megangiselle,
Conditional Formatting is the best choice when it is possible to use
because it does not involve macros and it does not matter if the the
content changed as values or through a formula. But if you need more than
a choice of 3 colors (+ default) then no matter how simple or complicated
your formulas are you would not be able to use C.F. for the fill color alone and
would have to use an Event macro instead, if you want it to be automatic.
http://www.mvps.org/dmcritchie/excel/event.htm#case
or a regular macro and run it yourself.
Back to Conditional Formatting, from the abiguity of your question
I expect that you will probably have to use the OR Worksheet Function
and possibly the LEFT and/or the AND worksheet function in your conditional formatting
formulas. You can get help for those in HELP if need them. Above all keep in
mind that the purpose of the C.F. formula is to return either TRUE (not zero) or
FALSE (zero).
