Conditional formatting

[Art]

In Excel 97, is there a way to have more than 3
conditional formats for a cell
(Format > Conditional Formatting)?

For example:
condition 1 = Green
condition 2 = Red
condition 3 = Yellow
condition 4 = Blue

 

[JE McGimpsey]

IF you're speaking of font color, you may be able to use the technique
show here:

http://www.mcgimpsey.com/excel/conditional6.html

If 1 of the four conditions must apply, then format the cell(s) with one
color and use the 3 conditional formats (i.e, color the cell blue with
regular formatting, and use the other three as conditionals).

Otherwise you'll need to use VBA. A search of the archives:

http://groups.google.com/advanced_group_search?q=group:*excel*

will show you hundreds of threads with various ways of accomplishing
this.