View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
watermt watermt is offline
external usenet poster
 
Posts: 82
Default Can I use 4 conditonal foamts in a column?

The conditional formatting in Excel 2003 is limited to 3 conditions. I need
four:

Bewteen:
13 - 16 = Red pattern
9 - 12 = Green pattern
5 - 8 = Yellow pattern
1 - 4 = Gray pattern

I thought I ran across a web page at one point where this was talked about
and that it is possible. Does anyone have an idea as to how to do this, or
where I can find a sample?

Mike