Conditional Formating

  • Thread starter Thread starter Ron
  • Start date Start date
R

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
 
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
 
Back
Top