Conditional Formatting - more than 3 options

[Bravo2003]

Ok, any help on this one...

spreadsheet of data I want to colour differnt rows of detail subject to a condition..

So far I have 3 formats done:
1: Formula is - =$C170="Product group level 1" (Format pattern Green)
2: Formula is - =$C170="Product" (Format pattern Yellow)
3: Formula is - =$C170="Product group level 3" (Format text Italic)

So, now I still need to format "Product group level 2"
and potentialy 1 or 2 more conditions...

Is this possible, or is there a way to condition as follows:
if C170="... level 2" and D170="T/.." format colour pattern yellow, otherwise no format.

D170 is likely to be T/TB or T/TA or T/TG or any other letter combination X/XX etc... but i want all T/XX to condition same..

Hope this makes sense and you can help.

Many thanks in advance..

 

[GlennUK]

Have you considered upgrading to Excel 2007? If you definitely can't, then look here:

http://www.ozgrid.com/VBA/excel-conditional-formatting-limit.htm