Conditional Formating

[Ron]

Is there any way to conditionally format more than three
conditions in Excel 2002 on XP? I'd like to color code
cells by year quarter and need 4 colors. Thanks

 

[Anders S]

Ron,

You're lucky. 4 colors is the maximum if you use the default color.

For example, set the colors for Q1-Q3 with CF 1-3, then set the cell color the
normal way (Format toolbar) for Q4.

HTH
Anders Silvén